How to find data between a specific two dates

Hi All - I'm hoping someone could kindly help me. I have some data with various dates and I want to return 'Yes' in a new column if the data is between 01/08/23 and 01/12/23 and 'No' if the date falls outside of this criteria. I know I can use the formula tool but not sure how I would write this statement. I have attached my data before and after so you can see what I'm trying to achieve. Any help would be appreciated

Date Check data.xlsx

Date Time

Transformation

Accepted answers

binu_acs

@binsell

IIF(DateTimeParse([SCSSTARTDATE],'%d/%m/%Y') >= '2023-08-01' AND DateTimeParse([SCSSTARTDATE],'%d/%m/%Y') <= '2023-12-01','Yes','No')

All comments

binu_acs

@binsell

IIF(DateTimeParse([SCSSTARTDATE],'%d/%m/%Y') >= '2023-08-01' AND DateTimeParse([SCSSTARTDATE],'%d/%m/%Y') <= '2023-12-01','Yes','No')

nagakavyasri

@binsell Another way:

Screenshot 2024-12-02 141301.png

12-02-24.1.yxmd

binsell

Thank you as always for your wonderful help!

binsell

Thank you for taking the time to reply

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335