My requirement is excel contains different date formats i have to parse for other formats and use cdate for conversion but problem i am facing is for yyyy format
i need to check the format whether it matches ‘yyyy’ and add 01-jan to it
@kavya.s16 , If you still need help, instead of sharing the whole Client Data, you could provide us with only the Date values being present in the Data. I do not think the dates would be any more of a confidential issue.
Also, for Parsing Multiple Date Formats, take a look at the below post :