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

[ShankerV]

Hi @Shaopingfu 

Step 1: Input tool

 

Step 2: Formula tool

Many thanks

Shanker V

[Shaopingfu]

Thanks. Can i have other solution about if Left [Date], 1,="4" . I may have other format of the date, maybe yyyy-mm-dd or yyyy-Apr-dd or dd-mm-yyyy & etc. 

[Yoshiro_Fujimori]

Hi @Shaopingfu ,

You may want to check the solution of this weekly challenge.

#4 Date Parsing

It contains a variety of date formats.

Good luck!