Omatic Support
How can we help you today?
european birthdate format conversion to american format
9 CommentsSorted by Newest First
Alas, no. Still not effective.
Any suggestions?
Any suggestions?
well, the problem is that somehow periods got put in after the \d
I'll just blame cut & paste or something. The good formula is
^(\d+)/(\d+)/(\d+)$
I'll just blame cut & paste or something. The good formula is
^(\d+)/(\d+)/(\d+)$
reg expressions box is checked, yes.
not sure i understand "it will return the same thing if it doesn't match the pattern." please clarify.
thanks!
not sure i understand "it will return the same thing if it doesn't match the pattern." please clarify.
thanks!
and you have the "Use Regular Expressions" checkbox checked?
It will return the same thing if it doesn't match the pattern.
It will return the same thing if it doesn't match the pattern.
in testing the dictionary, it recreates the same date format as value to match.
for example: i type in 21/3/1995 and test it. the result is 21/3/1995.
for example: i type in 21/3/1995 and test it. the result is 21/3/1995.
what does it do? Did you test the dictionary? It might be something else in the process?
Hi Wayne,
no luck once I plugged the reg ex in as a dictionary.
might there be an alternate option?
Thanks,
Sara
no luck once I plugged the reg ex in as a dictionary.
might there be an alternate option?
Thanks,
Sara
Thanks so much!
Sara
you can do this with a dictionary
Value to match: ^(\d.+)/(\d.+)/(\d.+)$
Replacement: $2/$1/$3
make sure to turn regex on!
Value to match: ^(\d.+)/(\d.+)/(\d.+)$
Replacement: $2/$1/$3
make sure to turn regex on!
Help Desk Software
by Freshdesk
AUP Database Wizard
Hi there,
Can anyone help determine a method to do the following:
we receive data on our incoming students with birthdates in the day/month/year format but our Raiser's Edge configuration takes the American style of month/day/year.
Is there anyway I can convert these birthdates on import?
Thanks very much!
Sara