Again a little question about datefields
I have a datefield where i now use the calenderpicker but i want to have this date in another field (call it EDITDATE) where the date is YYYYMMDD.
Erolst was so friendly to provide me this code a month ago :
Let ( dus = "DATEFIELD ; Left ( dus ; 4 ) & Middle ( dus ; 5 ; 2 ) & Right ( dus ; 2 ) )
Which worked, but when i use a calenderpicker it uses another dateformat i quess
In the dateformating is used all kinds of stuff but maybe it's late but i keep getting the wrong format, i think it has something to do with the fact that is say 26-12-2014 but also 26-1-2014 so without the zero.at the januari month.
The dateformat in my country is dd-mm-yyyy and it has to be formatted to yyyymmdd so without the "-"'s
Much oblidged for reading and perhaps helping out