AnsweredAssumed Answered

Datefields Again :)

Question asked by bartprins on Jan 26, 2014
Latest reply on Jan 27, 2014 by user19752

Hi there,


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 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