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

 


Outcomes