Hi @Shaopingfu
This can be achieved with the help of Formula tool.
IF Left([Date],1) = '4'
THEN 'Yes'
ELSE 'No'
ENDIF
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.
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!