Filtering 2 date parameter using "or"

Question

Hi All,

I'm trying to filtering out 2 date from a field of dates but its only returning the first date not both any ideas? Thanks.

Looking to get me last day of prior month or last day of prior year. below only gives me the last day of prior month.

[Report Date]=left(DateTimeAdd(DateTimeFirstOfMonth(),-1,"day"),10)
or
[Report Date]=left(DateTimeAdd(DateTimeFormat(DateTimeToday(),"%Y-12-31"),-12, "MONTHS"),10)

atcodedog05 · Answer

ok cool then @BosKev 🙂👍

BosKev · Answer

Thanks @atcodedog05 looks like the table did not include prior year, formula is ok. trying to delete this post....

atcodedog05 · Answer

Hi @BosKev

Did you check

DateTimeFormat(DateTimeToday(),"%Y-12-31")

Is this working properly. Just a hunch "%Y-12-31" this might not be a accepted format.