Calc column Flag if between two dates

[domtrump]

Just need a simple calculated column

=if(MOHDEP1[FDDate]>= "03/01/23", 1,0)

This errors out. What is the proper syntax to do a simple date comparison? 

=if(MOHDEP1[FDDate]>= date(2023,3,1), 1,0) works, but I would think there is a shorter way to write this code?

Same with BETWEEN. To create a calculated column to flag records between two dates, is there a better way to write:

=if(MOHDEP1[FDDate]>= date(2023,3,1) && MOHDEP1[FDDate]<= date(2023,6,30), 1,0) ?

Thanks.

[tamerj1 · Accepted solution]

Hi @domtrump 

there are other few ways to that but they're no better than this one. You my use DATEVALUE or CONVERT-DATETIME but nothing I personally prettge DATE approach. No need to be frustrated I guess.