Date conversion from queue

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

Hi @shanti_18

What is the variable type of in_Birthdate?

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


Hi @shanti_18

HI @shanti_18

Just simply use CDate



string is the type

not working

Can you try above expression @shanti_18

Have you tried this? @shanti_18

thanks the error is not showing, but will try

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

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