Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When loading a date field I use the following script to transform it to a date field:
date#(Transactiedatum,'DD-MMM-YYYY') as Transactiedatum2
This works fine for most of the records but not all:
result:
attached is the sourcefile. I can't see what is wrong with those specific dates.
Any suggestion would be welcome.
Remove all the full stop as such.
SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';
The format doesn't probably match the set format-pattern within the interpretation-variables - usually at the beginning of the script. I could imagine that instead of 'okt' there is 'oct' specified ...
- Marcus
I had the following :
SET MonthNames='jan.;feb.;mrt.;apr.;mei.;jun.;jul.;aug.;sep.;okt.;nov.;dec.';
you notice the period after each month.
If I remove all those periods, then it works. But howcome it worked for the other months ?
Remove all the full stop as such.
SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';
Question remains why the problem only occurred for 'okt' and 'mrt'.
Thinkable are various causes which may impact these results, for example:
- Marcus