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.
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
I don’t need to change the format. If the format is not correct the process should not move forward