Date function to say true or false

[Inactive User]

Hello,

Using formula i want to categorize as "YES" or "No" - for example if my date range is as of "01/01/2021" and look up with "01/01/2011", then it should perform greater or lesser function and provide my an output as "Y"or "N". Kindly advice.

Thanks,
Guru

[Emil_Kos · Accepted solution]

Hi @Inactive User,

As a first step, you need to convert the data into the correct format. I have assumed that the first data is in the format below:

dd/mm/yyyy

If it isn't you will need to switch this formula:

DateTimeParse([Date],'%d/%m/%y')

to 

DateTimeParse([Date],'%m/%d/%y')

[Inactive User]

Hi @Emil_Kos 

I tried the logic , the output is not per expected. - can you verify below data and let me know how i can build a logic.

=IF(A17<B17,"N","Y") is the formula that used in excel. 

trandate	Adj date	Formula
1/29/1950	1/1/2011	N
1/28/1950	1/1/2011	N
1/28/1950	1/1/2011	N
1/29/1950	1/1/2011	N
1/29/1950	1/1/2011	N
1/26/1950	1/1/2011	N
3/30/2020	1/1/2011	Y
4/3/2020	1/1/2011	Y
4/3/2020	1/1/2011	Y
4/8/2020	1/1/2011	Y
4/8/2020	1/1/2011	Y
5/5/2020	1/1/2011	Y
5/5/2020	1/1/2011	Y
5/6/2020	1/1/2011	Y
5/7/2020	1/1/2011	Y
5/7/2020	1/1/2011	Y

Thanks,
Guru

[tonypreece]

With your dates in the right format the equivalent formula to your Excel is:

IIF([trandate]<[Adj date],"N","Y")

[Inactive User]

Hi @tonypreece 

Its shows all values as "Y"" by using this formula - IIF([trandate]<"2011-01-01","N","Y")

is there any way to constant 01/01/2011 and convert to date  ? please advice.

Thanks,

Guru  

[Inactive User]

I revisited the logic and its working fine. Thank so much ! 

[Luke_C · Accepted solution]

@Inactive User 

Both of the solutions above should work fine, see attached with the adj date referenced and with it hardcoded.