Date format to full length

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”)

2 Likes

Still the same

Okay. Can you send me the excel file?

1 Like

nope sorry it is confidential information.

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

2 Likes

For Brian.xls (33.4 KB)
Here you go

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

Let me know if this works :slight_smile:

8 Likes

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.

1 Like

Try to add .ToString on the Assign activity

Error that gives me


The assign line

1 Like

Add .ToString at the end

1 Like

same error as the last one

1 Like

But in your workflow, it gives the right output in the message box?

2 Likes

yes but i think we fixed it. But i have another value with the same thing. So need to change it the same way and then it will work. I will let you know

1 Like

Sure :slight_smile:

2 Likes

we fixed it thank you so much!!!

1 Like

Good to hear that!
Just let me know if you need more assistance :slight_smile:
Thanks and regards!

1 Like

hahah i will.
Now i only need to fix that the month names are in the Dutch language

1 Like

Okay :slight_smile:

1 Like

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