How to check if a value is a date

[bobby (Bob Master)]

I get a date from excel and store it into a string. Once in a string, I convert it into a DateTime object. But I want to set up an if condition to check if the value is a date then convert it. Not sure how to check if the value is a date.

Can anyone help?

[KarthikByggari]

You can use Try Parse .

More details are here -

DateTime.TryParse Method (System)

Regards,
Karthik Byggari

[Mohansadaiyapillai (Mohanraj S)]

Have created a workflow based on your requirement.

Please mark as this solution if it is resolved.
DateFormat.zip (24.2 KB)

[Palaniyappan (Palaniyappan P)]

If suppose your DateTime value is stored in a str_datetime which is format “dd/MM/yyyy hh:mm:ss” then use this expression in a IF condition

Date.TryParseExact(str_datetime.ToString.SubString(0,10),“dd/MM/yyyy”,Nothing,Globalization.DateTimeStyles.None,Nothing)

Cheers @bobby

[bobby (Bob Master)]

I got it working. Thanks @Palaniyappan. Also, thanks for taking the time to answer my question. @Mohansadaiyapillai and @KarthikByggari. Great suggestions as well.

Thanks guys.