Examples for Date and Time Values
This section presents a few examples of date and time values generation.
DefinitionPatternSample output
One year after entered date$$($Date(12.10.2008,DD.MM.YYYY)+365)12.10.2009
Random date between 1999-01-01 and today$RDate(YYYY-MM-DD,1999-01-01,$Today(YYYY-MM-DD))2009-10-04
Random date between "BirthDay" column + 18 years and today$RDate(YYYY-MM-DD,$$(@'BirthDate'+365*18),$Today(YYYY-MM-DD))2000-12-01
Random date between 1999-01-01 and today - 18 years$RDate(YYYY-MM-DD,1930-01-01,$$($Today(YYYY-MM-DD)-18*365))1999-11-21