How to find data between a specific two dates

[binsell]

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 :) 

[binuacs · Accepted solution]

@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:

[binsell]

Thank you as always for your wonderful help! :)

[binsell]

Thank you for taking the time to reply :)