DatastoreDateAsDefault

From SMTX Wiki
Jump to navigation Jump to search

An entry of a date in a datatore field is stored as dd/MM/yyyy

but to set a default date in a datafield , you need in as yyyyMMdd, so we need to convert it in a hidden field

suppose we find the datafield from another field, called 'Start date' then do this first, call this field 'EndDateHidden' :

     format('{0:yyyyMMdd}',TODATE('#REPLACE-FORMFIELD-HREXTChACED||ActiveExtension||End date#'))