Date time formular

Shaopingfu

If I want to have value "yes" when the month in date list is in Apr, and "No" for date in any other months, how can I use the date time phrase? 

Date	Value
4/30/2021	Yes
8/7/2021	No
3/25/2022	No
4/28/2022	Yes
2/18/2023	No
4/12/2023	Yes
6/9/2023	No
11/17/2023	No

ShankerV

Hi @Shaopingfu 

This can be achieved with the help of Formula tool.

IF Left([Date],1) = '4'

THEN 'Yes'

ELSE 'No'

ENDIF