For a long time I have one problem that I’m thinkering aound but couldn’t find solution.
I need to change Variable result for Date, based on source from Excell.
I figured out how to change format, but for long version ( e.g. 1 Januar 1999 ) month is fixed to language that is selected by function. I also know that date format is changing depending on local code selected.
This is what I have now, unfortunately name of month is not changing (it stays in local selected for DATE function), just format changes.
IF([Sp]="1",DATE([Geburtsdatum],"d. mmmm yyyy"),"")&IF([Sp]="2",DATE([Geburtsdatum],"d mmmm yyyy"),"")&IF([Sp]="3",DATE([Geburtsdatum],"d mmmm yyyy"),"")
Example of excell data would be:
SP; Name; DOB;
1; John; 19990101;
2; Mathew; 19800101;
3; Stefan; 19700101;
SP=language (1-English, 2-French, 3-German), DOB=Date of Birth
Result variable should look like:
January 1, 1999
1 janvier 1980
1. Januar 1970
Does anyone know is this possible to do automaticaly by defining in function/script?
Many helps for advice or solution,