Date conversion from queue

[shanti_18 (shane hyung)]

good day, do you know how can I fix this?

im getting a data from orcherstrator queue the bday format in queue is yyyy-mm-dd

[Gokul001 (Gokul Balaji)]

Hi @shanti_18

What is the variable type of in_Birthdate?

[Sudharsan_Ka]

HI @shanti_18

If your in_Birthdate is a string means try like below expression

DateTime.ParseExact(in_Birthdate,{"dd/MM/yyyy hh:mm:ss","MM/dd/yyyy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).Tostring("MMddyyyy")

If your date in the queue has different format you can add the other formats inside the {“”,“”}
Each format is a string and it is seperated by comma

Regards
Sudharsan

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @shanti_18
birthdate.tostring(“MM/dd/yyyy”)

[Gokul001 (Gokul Balaji)]

HI @shanti_18

Just simply use CDate

CDate(in_Birthdate).Tostring("MMddyyyy")

Regards
Gokul

[shanti_18 (shane hyung)]

@Gokul001

CDate(in_Birthdate).Tostring("MMddyyyy")

string is the type

[shanti_18 (shane hyung)]

not working

[Gokul001 (Gokul Balaji)]

@Gokul001

CDate(in_Birthdate).Tostring("MMddyyyy")

Can you try above expression @shanti_18

[Sudharsan_Ka]

Have you tried this? @shanti_18

[shanti_18 (shane hyung)]

thanks the error is not showing, but will try

[Gokul001 (Gokul Balaji)]

Great @shanti_18 , Let us know , If you face any issue