date format

[45134904]

in this below screen shot date variable I want a logic that if the variable records are in DDMMYYYY format then its true other wise false

[binuacs]

@45134904

 IIF(isNull(DateTimeParse([Date],'%d%m%Y'),'False','True')

[45134904]

 I need also  A1_start date should grater than 01/07/2022.

[DataNath]

Try a filter with the following:

DateTimeParse([A1_START_DATE],”%d%m%Y”) > 2022-07-01

(If you mean 7th January then would be 2022-01-07 rather than the above).

[flying008]

HI,@45134904 

as your said, the formula : 

iif(DateTimeDiff(DateTimeParse(tostring([A1_START_DATE]),"%d%m%Y"),"2022-07-01","days")>0,"True","False")