Datechange

Help Studio
1

hi
need help by change date formate

have this format:
yyyymmdd

need to print in this format:
ddmmyyyy

thanks

2

Hi @nir.kail ,

you can use the following expression:

Cdate("DateString").tostring("ddMMyyyy")

or

DateTime.ParseExact("DateString", "yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture).tostring("ddMMyyyy")

Regards,

2 Likes
3

@nir.kail ,

DateTime.ParseExact(InputDate, "yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture).ToString("ddMMyyyy")

Regards,

4

@nir.kail

If you are getting value this from an excel then write as below

Cdate(Value).Tostring("ddmmyyyy")

Hope this may help you

Thanks,
Srini

5

Hi @nir.kail

How about this date expression?

DateTime.ParseExact(StringInput,"yyyymmdd",System.Globalization.CultureInfo.InvariantCulture).ToString("ddmmyyyy")

Regards
Gokul

1 Like
6

hi
getting this error:

Error ERROR Validation Error Compiler error(s) encountered processing expression “CDate(“DateString”).tostring(“ddMMyyyy”)”.
Option Strict On disallows implicit conversions from ‘String’ to ‘Date’.

7

@nir.kail Try the other one:

Replace the “DateString” with the date string variable or the date string

DateTime.ParseExact("DateString", "yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture).tostring("ddMMyyyy")

regards,

8

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