If statement for date giving wrong answer

[CloudMonkey]

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" or "During" the pricing trial period which started on the 5th June 2017. The if formula is shown in the formula bar in the screenshot below. My problem is that the formula is incorrectly flagging records from 31 December 1899 as "During", whereas it should be lableing records from 5th June 2017 as "During". Please could you tell me how to fix it?

Thanks,

CM

[Interkoubess · Accepted solution]

Hi @CloudMonkey,

Please add date to the date as below

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

Ninter

[Ashish_Mathur · Accepted solution]

Hi,

Try this

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

Hope this helps.

[Interkoubess · Accepted solution]

Hi @CloudMonkey,

Please add date to the date as below

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

Ninter