Date time struggles

[chiragpatel_1]

Just been cheeky!

I have the below formula ad for some odd reason it is missing out the last day of May, (the 31st), what changes do i have to make in the formula

DateTimeMonth([Workflow Run])=DateTimeMonth(DateTimeNow())-1

//is it MTD?

very many thanks

[binuacs]

@chiragpatel_1 IF you are looking for the last day of the previous month you can use the formula 

[Workflow Run] == DateTimeAdd(DateTimeToday(),-DateTimeDay(DateTimeToday()),'days')

[chiragpatel_1]

Hi Thank you, just to clarify, i don't want the last day in isolation, but I want all the days so below there should be another line for 31st

[binuacs · Accepted solution]

@chiragpatel_1 yes, you need to use the >= in the filter condition. also please check your data has the date value 5/31?