DatastoreDateAsDefault

From SMTX Wiki
Revision as of 11:23, 19 December 2016 by Smtxwiki (talk | contribs) (Created page with "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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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#'))