Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

If statement for date giving wrong answer

Hi,   In the screenshot below I have a date field (first column) created using the CALENDARAUTO() function. The last field PricingTrialBeforeDuringOrAfter should flag each record as being "Before" ...
Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi Anonymous,

     

    Please add date to the date as below

     

    PricingTrialBeforeDuringorAfter=IF([Dare].[Date]>date(2007,06,05),"During","Before")

     

    Ninter

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    =IF([Date]>DATE(2017,6,5),"During",Before")

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

=IF([Date]>DATE(2017,6,5),"During",Before")

 

Hope this helps.