Ttdfjt

To whom did Varys write those letters in Game of Thrones S8E5?

Using chord iii in a chord progression (major key)

Why is the Advance Variation considered strong vs the Caro-Kann but not vs the Scandinavian?

Polynomial division: Is this trick obvious?

Can I say: "When was your train leaving?" if the train leaves in the future?

Are there microwaves to heat baby food at Brussels airport?

Is there an academic word that means "to split hairs over"?

Why commonly or frequently used fonts sizes are even numbers like 10px, 12px, 16px, 24px, or 32px?

What is the status of the Lannisters after Season 8 Episode 5, "The Bells"?

Were any of the books mentioned in this scene from the movie Hackers real?

Were any toxic metals used in the International Space Station?

Network latencies between opposite ends of the Earth

Why did the metro bus stop at each railway crossing, despite no warning indicating a train was coming?

Could there be something like aerobatic smoke trails in the vacuum of space?

Why are lawsuits between the President and Congress not automatically sent to the Supreme Court

How could it be that 80% of townspeople were farmers during the Edo period in Japan?

​Cuban​ ​Primes

Developers demotivated due to working on same project for more than 2 years

What is this weird d12 for?

What was Varys trying to do at the beginning of S08E05?

Assembly writer vs compiler

Why does SSL Labs now consider CBC suites weak?

Is there any deeper thematic meaning to the white horse that Arya finds in The Bells (S08E05)?

Why did Varys remove his rings?

Apply Date Filter With “not qual to” Condition in Magento 2

Customer created_at Date off by monthsShow Deal only if its starting from todays dateShow product only within a date range (between start date and end date)How do I filter categoryIds or categoryId with only existing in current store?Filter Magento collection with nested “OR” “AND” filterMagento 2: Filter order collection on “created_at” attributeBestseller Products Collection Not coming zero for current month and day even it is using old collection magento 2?Custom Customer attribute grid not filter by asc or decSales Order Grid Filter issue with custom column - Magento 2How to filter the date with not this(current) month in magento 2

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

i need to filter with a date column with not
current month records

i tried :

 $start = date('Y-m-d'.' 23:59:59',strtotime('-45 days'));
 $end = date('Y-m-d'.' 00:00:00'); 
 $collection = $collection
 ->addFieldToFilter('created_at',array('from' => $start, 'to' => $end));

this is Showing only Expect the this two month records

but how i can put "Not equal to"

magento2 php date

share|improve this question

edited May 10 at 14:03

prabhakaran7

asked May 10 at 13:28

prabhakaran7prabhakaran7

30012

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What's your goal?
  
  – Keyur Shah
  May 10 at 13:31
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i won't need this month record how i can filter that???
  
  – prabhakaran7
  May 10 at 13:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  order colletion ??
  
  – Rk Rathod
  May 10 at 13:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  no custom table
  
  – prabhakaran7
  May 10 at 13:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check my answer
  
  – Rk Rathod
  May 10 at 13:38
  

  
  
  
  

add a comment | 

0

i need to filter with a date column with not
current month records

i tried :

 $start = date('Y-m-d'.' 23:59:59',strtotime('-45 days'));
 $end = date('Y-m-d'.' 00:00:00'); 
 $collection = $collection
 ->addFieldToFilter('created_at',array('from' => $start, 'to' => $end));

this is Showing only Expect the this two month records

but how i can put "Not equal to"

magento2 php date

share|improve this question

edited May 10 at 14:03

prabhakaran7

asked May 10 at 13:28

prabhakaran7prabhakaran7

30012

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What's your goal?
  
  – Keyur Shah
  May 10 at 13:31
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i won't need this month record how i can filter that???
  
  – prabhakaran7
  May 10 at 13:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  order colletion ??
  
  – Rk Rathod
  May 10 at 13:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  no custom table
  
  – prabhakaran7
  May 10 at 13:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check my answer
  
  – Rk Rathod
  May 10 at 13:38
  

  
  
  
  

add a comment | 

i need to filter with a date column with not
current month records

i tried :

 $start = date('Y-m-d'.' 23:59:59',strtotime('-45 days'));
 $end = date('Y-m-d'.' 00:00:00'); 
 $collection = $collection
 ->addFieldToFilter('created_at',array('from' => $start, 'to' => $end));

this is Showing only Expect the this two month records

but how i can put "Not equal to"

magento2 php date

share|improve this question

edited May 10 at 14:03

prabhakaran7

asked May 10 at 13:28

prabhakaran7prabhakaran7

30012

 $start = date('Y-m-d'.' 23:59:59',strtotime('-45 days'));
 $end = date('Y-m-d'.' 00:00:00'); 
 $collection = $collection
 ->addFieldToFilter('created_at',array('from' => $start, 'to' => $end));

share|improve this question

edited May 10 at 14:03

prabhakaran7

asked May 10 at 13:28

prabhakaran7prabhakaran7

30012

share|improve this question

edited May 10 at 14:03

prabhakaran7

asked May 10 at 13:28

prabhakaran7prabhakaran7

30012

asked May 10 at 13:28

prabhakaran7prabhakaran7

30012

asked May 10 at 13:28

prabhakaran7prabhakaran7

30012

1 Answer
1

active

oldest

votes

0

Try This :-

$start = date("Y-m-d h:m:s", strtotime(2019-3-1)); //Pass 1st month Starting Date
$end = date("Y-m-d h:m:s", strtotime(2019-3-29)); //Pass 1st month Ending Date

$collection=$collection->addFieldToFilter('created_at', ['gteq' => $start])
 ->addFieldToFilter('created_at', ['lteq' => $end]);

share|improve this answer

edited May 10 at 14:07

answered May 10 at 13:38

Rk RathodRk Rathod

1,788214

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s), query was: SELECT COUNT(*) WHERE (main_table.created_at != '2019-03-26 23:59:59', '2019-05-10 00:00:00'
  
  – prabhakaran7
  May 10 at 13:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check updated answer
  
  – Rk Rathod
  May 10 at 13:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  but showing this month records
  
  – prabhakaran7
  May 10 at 13:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  which record you want to display ???
  
  – Rk Rathod
  May 10 at 13:51
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  GOAL : I won't need this current month records...
  
  – prabhakaran7
  May 10 at 13:52
  

  
  
  
  

 | 
show 11 more comments

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f274179%2fapply-date-filter-with-not-qual-to-condition-in-magento-2%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Try This :-

$start = date("Y-m-d h:m:s", strtotime(2019-3-1)); //Pass 1st month Starting Date
$end = date("Y-m-d h:m:s", strtotime(2019-3-29)); //Pass 1st month Ending Date

$collection=$collection->addFieldToFilter('created_at', ['gteq' => $start])
 ->addFieldToFilter('created_at', ['lteq' => $end]);

share|improve this answer

edited May 10 at 14:07

answered May 10 at 13:38

Rk RathodRk Rathod

1,788214

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s), query was: SELECT COUNT(*) WHERE (main_table.created_at != '2019-03-26 23:59:59', '2019-05-10 00:00:00'
  
  – prabhakaran7
  May 10 at 13:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check updated answer
  
  – Rk Rathod
  May 10 at 13:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  but showing this month records
  
  – prabhakaran7
  May 10 at 13:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  which record you want to display ???
  
  – Rk Rathod
  May 10 at 13:51
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  GOAL : I won't need this current month records...
  
  – prabhakaran7
  May 10 at 13:52
  

  
  
  
  

 | 
show 11 more comments

0

Try This :-

$start = date("Y-m-d h:m:s", strtotime(2019-3-1)); //Pass 1st month Starting Date
$end = date("Y-m-d h:m:s", strtotime(2019-3-29)); //Pass 1st month Ending Date

$collection=$collection->addFieldToFilter('created_at', ['gteq' => $start])
 ->addFieldToFilter('created_at', ['lteq' => $end]);

share|improve this answer

edited May 10 at 14:07

answered May 10 at 13:38

Rk RathodRk Rathod

1,788214

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s), query was: SELECT COUNT(*) WHERE (main_table.created_at != '2019-03-26 23:59:59', '2019-05-10 00:00:00'
  
  – prabhakaran7
  May 10 at 13:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check updated answer
  
  – Rk Rathod
  May 10 at 13:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  but showing this month records
  
  – prabhakaran7
  May 10 at 13:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  which record you want to display ???
  
  – Rk Rathod
  May 10 at 13:51
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  GOAL : I won't need this current month records...
  
  – prabhakaran7
  May 10 at 13:52
  

  
  
  
  

 | 
show 11 more comments

Try This :-

$start = date("Y-m-d h:m:s", strtotime(2019-3-1)); //Pass 1st month Starting Date
$end = date("Y-m-d h:m:s", strtotime(2019-3-29)); //Pass 1st month Ending Date

$collection=$collection->addFieldToFilter('created_at', ['gteq' => $start])
 ->addFieldToFilter('created_at', ['lteq' => $end]);

share|improve this answer

edited May 10 at 14:07

answered May 10 at 13:38

Rk RathodRk Rathod

1,788214

$start = date("Y-m-d h:m:s", strtotime(2019-3-1)); //Pass 1st month Starting Date
$end = date("Y-m-d h:m:s", strtotime(2019-3-29)); //Pass 1st month Ending Date

$collection=$collection->addFieldToFilter('created_at', ['gteq' => $start])
 ->addFieldToFilter('created_at', ['lteq' => $end]);

share|improve this answer

edited May 10 at 14:07

answered May 10 at 13:38

Rk RathodRk Rathod

1,788214

answered May 10 at 13:38

Rk RathodRk Rathod

1,788214

answered May 10 at 13:38

Rk RathodRk Rathod

1,788214