Forum Discussion

domtrump's avatar
domtrump
Helper II
3 years ago
Solved

Calc column Flag if between two dates

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's avatar
    tamerj1
    3 years ago

    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. 

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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.