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 on screen will have its appearance modified so that it is in the time or date style specified for that cell.
Any times or dates 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 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.