Date and time functions provide a variety of operations on numbers and text strings which enable you to work with dates and times.
Note that the output of many of these functions which you see displayed on screen will have its appearance modified so that it is in the date or time style specified for the containing cell.
Any dates and times input to all these functions must be supplied in a format which Fireworkz can recognise.
Dates should be entered in the form
day.month.year
where the components are expressed in figures (not words) with or without leading zeros.
There must be two full stops and no spaces within the date.
If you only give two digits of the year, Fireworkz will use a sliding window to determine the appropriate century.
Times should be entered in the form
hours:minutes{:seconds}
where the components are expressed in figures with or without leading zeros.
There must be colons between the figures and no spaces within the time.