DatastoreDateAsDefault: Difference between revisions

From SMTX Wiki
Jump to navigation Jump to search
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..."
 
m 1 revision imported
 
(No difference)

Latest revision as of 21:44, 25 May 2020

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#'))