this is the data that I’m getting from the orchestrator queue
I only need the date
this is my variable
and this is the assign activity
anyone know what to do?
output should be 08011963
Hi @shanti_18
Do it like this DateTime.ParseExact(in_Birthdate,“MM/dd/yyyy hh:mm:ss”,System.Globalization.CulturalInfo.InvariantCulture).ToString(“MMddyyyy”)
Your output will be a string
cheers
this is the error when I try ur code
Hello @shanti_18
If you want to change the format using the activity, you can use the Modify Date activity.
Thanks
Hi @shanti_18
Can you print your in_birthdate once …and check if there are any extra spaces. If you have spaces at the ends just use in_birthdate.Trim else if there are in between date and time then include the extra spaces in the format of datetime.parseexact
Is your month coming first in your in_birthdate?? Else inter change MM and dd in the format and use dd/MM/yyyy hh:mm:ss
Cheers
@Yoichi hello sir, do you know how to solve this issue?
HI,
Can you try the following expression?
DateTime.Parse(System.Text.RegularExpressions.Regex.Match(in_birthdate,"\b\d{1,2}/\d{1,2}/\d{4}\b").Value).ToString("MMddyyyy")
OR
System.Text.RegularExpressions.Regex.Replace(in_birthdate,"^.*\b(\d{2})/(\d{2})/(\d{4})\b.*$","$1$2$3")
Regards,
“\b\d{1,2}/\d{1,2}/\d{4}\b” what is the meaning or purpose of this ?
Hi,
“\b\d{1,2}/\d{1,2}/\d{4}\b” what is the meaning or purpose of this ?
In order to extract just “08/01/1963” part.
\b means word boundary.
\d means numeric chracter and {1,2} means one or two, {4} means four characters.
So, regex pattern “\b\d{1,2}/\d{1,2}/\d{4}\b” can extract “08/01/1963”
Regards,
thank you will definitely try this
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 {“”,“”}
Or
CDate(in_Birthdate).Tostring("MMddyyyy")
Regards
Gokul
Hi @shanti_18
Please use a log message/write line activity and write the date to your output console to check the format , and then give the format in this
DateTime.ParseExact(in_Birthdate,“MM/dd/yyyy hh:mm:ss”,System.Globalization.CulturalInfo.InvariantCulture).ToString(“MMddyyyy”)
Change MM/dd/yyyy hh:mm:ss
Cheers
Have you tried with this expressions @shanti_18
Have you tried with this @shanti_18
like this one sir?
Can you share the output after extracting the data from the website. @shanti_18
this is the one that I need to get from orchestrator queue the output should be 03112000
Hi @shanti_18
Yes please.please send the output as a screenshot … and i beleive birthdate is what you are using in date.parseexact if not whatever that you are using print that and show the output panel
Cheers