Check format of date in datatable

There is a data table of 50 columns and 100+ rows. Among the 50 columns there are 5 columns which have dates in string format.

I need to check if all the date values are in (DDMMMYY) format.

What is the fastest way to verify the format? If format is not correct , automation will stop.

Hi @pandeypriyanka1312

Instead of checking you can change the format as you want.

Go to Manage Package → Install → BalaReva Activity

Use the Change cell type activity

Have a view on the thread

Hope it will help you


1 Like

I don’t need to change the format. If the format is not correct the process should not move forward