Date format to full length

[438654]

First this one but i replace the Time to nothing. Also did this without replacing and gave the same error.

[Jan_Brian_Despi]

So here is the workflow: BlankProcess38.zip (11.5 KB)

[Jan_Brian_Despi]

First you will remove the 00:00:00.
Then instead of strDate in the message box, use the variable where the date is stored

[438654]

i did

[Jan_Brian_Despi]

New one: DateTime.ParseExact(strDate, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MMMM-yyyy”)

[Jan_Brian_Despi]

This is the previous one: DateTime.ParseExact(strDate, “dd-MM-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MMMM-yyyy”)

[438654]

i already use this one

[438654]

both not working

[Jan_Brian_Despi]

Please upload the zipped folder of your project

[438654]

Contractopstellen.zip (16.9 KB)

[Jan_Brian_Despi]

Please try this: startdatum.Replace(" 00:00:00", “”) instead of startdatum.Replace(“00:00:00”, “”) and
DateTime.ParseExact(startdatum.ToString, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MMMM-yyyy”) instead of DateTime.ParseExact(startdatum, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MMMM-yyyy”)

[438654]

Still the same

[Jan_Brian_Despi]

Okay. Can you send me the excel file?

[438654]

nope sorry it is confidential information.

[Jan_Brian_Despi]

Yep! That is what I am thinking.
Please remove the sensitive information. I just need the template and the date column

[438654]

For Brian.xls (33.4 KB)
Here you go

[Jan_Brian_Despi]

Hi @438654,
Please check this sample: BlankProcess39.zip (11.7 KB)

Let me know if this works

[438654]

I think we are almost there. The message box displays what we want but assigning it with the same thing as the messagebox still gives the same error. So i think the solution isn’t able with an assign or an Generic Value.

[Jan_Brian_Despi]

Try to add .ToString on the Assign activity

[438654]

Error that gives me

The assign line