Forum Discussion

domtrump's avatar
domtrump
Icon for Helper II rankHelper 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), ...
  • 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. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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.