M code for same date last year

[Joanne 56]

Hi. I have a problem that is driving me nuts. Am fairly new to M code but thought trial and error would have solved my problem by now. Upside is I have learned a lot on the way even if I still haven't solved my problem. I have a (text) column called EntryDate with the date of all orders keyed over a number of years, and another column called Year which shows the year the order was received. I am wanting to add a custom column for year to date orders from last year (if entry date matches year to date last year then 1, else 0) so I can compare with this year.

Can someone please help out?

 

[Norie]

So if value in Year matches last year, e.g. 2018, return 1 else return 0?

 

[Joanne 56]

Yip - so if the EntryDate = between 01/01/18 and today's day and month and the year is 2018 then return 1 else return 0. Thanks.