Ttdfjt

2 parabolas through 4 points

Were any toxic metals used in the International Space Station?

Using chord iii in a chord progression (major key)

Wifi is sometimes soft blocked by unknown service

​Cuban​ ​Primes

Wireless headphones interfere with Wi-Fi signal on laptop

Meaning of "legitimate" in Carl Jung's quote "Neurosis is always a substitute for legitimate suffering."

Can a tourist shoot a gun in the USA?

How to continually let my readers know what time it is in my story, in an organic way?

Will there be more tax deductions if I put the house completely under my name, versus doing a joint ownership?

Does the wearer know what items are in which patch in the Robe of Useful items?

Will the volt, ampere, ohm or other electrical units change on May 20th, 2019?

How does Ctrl+c and Ctrl+v work?

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

What are the implications of XORing ciphertext with plaintext?

Wiring a 4 channel relay - is this possible?

Is my test coverage up to snuff?

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

tikz drawing rectangle discretized with triangle lattices and its centroids

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

Do people who work at research institutes consider themselves "academics"?

How will the lack of ground stations affect navigation?

Why does SSL Labs now consider CBC suites weak?

What do you call the hair or body hair you trim off your body?

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