Change Format of Date Variable

Hello guys !

I want to change a DateTime format.
Could you help me for this issue, I get this following error message :

Many Thanks for your Help ! :slight_smile:

Hi, Can you please tell me which expression you used and in what format you want date?

Thanks for your help @Vashisht

I retrieve this format : “2019-03-28 - 06:17” from an extract data and I would like to change it to this one : “28 Mar 19 - 6:17 AM”

I post you my Sequence if you want to have a look Extract Data 2.0.xaml (14.8 KB)

refer this link choose whatever format you want

@AmauryCarlier Hey, Please check the below zip file it contains the excel sheet which contains date in normal format and the workflow converts it to your required format(28 Mar 19).
Check and let me know if any doubts.
If you find it useful mark it as solution and close the thread.

@Vashisht I can’t find your zip file, could you import it again ?

no worries buddy
if the input is like this in a string variable
str_datetime = "2019-03-28 - 06:17"
then the output string variable will be like this
out_strdatetime = Datetime.ParseExact(str_datetime,“yyyy-MM-dd - hh:mm”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd MMM yy - hh:mm tt”)

Cheers @AmauryCarlier

Thanks @Palaniyappan for your help !

Your process is good if str_datetime is like : “2019-03-28 - 06:17” but in my case my
str_datetime = sDate+" “+”-"+" "+sTime the result is the same : “2019-03-28 - 06:17”
sDate and sTime are variables built from extract data
I add my sequence ! :slight_smile:
Extract Data 2.0.xaml (15.5 KB)

Because of my str_datetime it’s still doesn’t work

Hi @AmauryCarlier
Sorry for that…
Check now. (18.3 KB)

1 Like

Many thanks @Vashisht ! It’s working !

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.