Format where clause with Carbon and check if date is in the past

@tykus Ok wow it's working even though I did not specify format. Does Laravel use Carbon to check every possible format under the hood?

@cooperino

Does Laravel use Carbon to check every possible format under the hood?

No.

This is a simple query where we are asking if date_field is less that today (i.e. 2022-05-15 00:00:00)

@tykus But my date field is not so standard, it's only 2 digit month and 2 digit years, i.e. 0522

@tykus Update: Ok my bad, it's not working :D It just returns true always if I just use < sign but it's not correct. I just tried:

$Model::whereDate('date_field','>', today())->get();

and the date was 0622 and it didn't work (returned empty collection), I need to format the date on the fly and I guess he doesn't know this format

@cooperino your date_field is what type in the database?

@tykus string

I made a query that works, however it doesn't work when we're on the same month, even though I use >=, but if the months are different that it seem to work:

Model::where(DB::raw("(STR_TO_DATE(ex_month_year,'%m%y'))"), ">=", Carbon::now())->get();

but it doesn't work if for example the date is today's month, i.e. 0522, any idea why?

@cooperino why are you storing dates as a my formatted string at all?

@tykus its for expiration date

@cooperino you're not storing users' credit card information in your database; or even handling users' credit card information on your server I hope!