Recently i’ve been struggling with getting the following to work.
I am analysing documents in order to fill in that input into a PeopleSoft environment.
The problem is that the input is not well standardized. So I need to put the date in the right order. (dd/mm/yyyy). The only input I am left struggling with is the following example:
1st January 1994 or just 1 January 1994
I was thinking about creating a list that replaces January, February, March,… with 01,02,03. But I can’t figure out how to make it work.
To make it even harder, I need it in two languages… (French and Dutch)
Can somebody help me out?