Insert a date control onto your XpressDox interview «ChooseUsingDatePicker(Date_of_signature)» will cause a date picker control to be used when the Date_of_signature data element is required to be captured. Like other Choose commands, the ChooseUsingDatePicker command will only be included in the interview if the data element referred to is used...
The DayBetween function returns the number of days between the two dates. For example: I was born on «FormatDate(DateOfBirth,‘d MMMM yyyy’)» which means I am «floor(DaysBetween(Today(),DateOfBirth) div 365.25)» years old.
Dates can be formatted according to patterns defined in the fillpoints. Command structure: «FormatDate(Date_of_Engagement,"yyyy-MM-dd")» «FormatDate(Date_of_Signature,"MMM d yyyy")» «FormatDate(Date_of_Dismissal,"d MMMM, yyyy")» «FormatDate(Date_of_Signature,"MMMM o yyyy")» «FormatDate(Date_of_Signature,"dddd MMMM o yyyy")» These examples would result in something like, respectively: 2019-02-07 Feb 7 2019 7 February, 2019 February 7th 2019 Thursday February 7th...
Date calculations: Increment a date by a certain number of days, months or years. First, some simple examples: Add 25 years to the value in the data element ‘DateOfBirth’: «IncrementDate(DateOfBirth,25, "y")» Insert tomorrow’s date into the document: «IncrementDate(Today(),1,"d")» i.e. add 1 day to today’s date. Insert yesterday’s date...
The MonthsBetween function returns the number of months between the two dates. Below are 2 examples of the function: «Comment(Pass in 2 data elements, a start and an end date)» «MonthsBetween(FirstDate,Secondate)» «Comment(Another example is where one of the parameters is a function such as Today())» «DaysBetween(ChooseMonth,Today())» «ChooseUsingDatePicker(ChooseMonth)»
