How to check the dateformat in excel is 'yyyy' and add 01-Jan-yyyy' to it

[kavya.s16]

Hi everyone,

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

could u please help @palaniyappan

thanks in advance

[lakshman (Ganta lakshman)]

@kavya.s16

Can you please share screenshot of the sample data. So that we can check and help you.

[kavya.s16]

apologies , will not able to share screenshot as its client data , but yeah i need to parse dates in yyyy formats eg:2019

[indra]

@kavya.s16

• Use Is match activity and check if year contains four digits this will store in Boolean variable

• Use if condition and if it is true add date

[supermanPunch (Arpan)]

@kavya.s16

will not able to share screenshot as its client data

@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 :

How to Convert multiple column date format in data table using linq(With out foreach)

@BalaM1510 the main building block is an array with formats: [grafik] which can be used DateTime.ParseExact(YourDateString, arrFormats, YourCultureInfo, DateTimeStyles.None) from your question it can be derived: a column with date strings is the input for a dateTime.ParseExact the conversion result will update the value within the column LINQ could be used for this. But as we have to be prepared for conversion fails LINQ is less helfull for this due: ALL or Nothing is converted intran…