Date formats

Date field and formats

This field can be used to enter a date. The exact format for the field will depend on what date format you selected in your Edit iconeditable user preferences. If the system is not 100% about the date you have entered it will make its best guess and present the date back to you for confirmation.Below are some alternative date formats that you can try:
FormatExample
dd-mm-yyyy24-02-2008
dd/mm/yyyy24/02/2008
ddmmyyyy24022008
yyyy-mm-dd2008-02-24
yyyy/mm/dd2008/02/24
yyyymmdd20080224
yy-mm-dd08-02-24
dd mmm yyyy24 Feb 2008
dd month yyyy24 February 2008
+/- # months/weeks+3 months

Date picker

You can use the date picker by clicking the Calendar icon calendar icon. Here you can select a specific date by clicking on the day you want to add. You can use the dropdowns to change the months and the years.

Dropdown options

If this date field has a dropdown of options, this means you can use dates such as ‘Last financial year’ where it will automatically grab that date. You can see next to the dropdown what that date would be relative to now (if you are using scheduled reports, this date would be wrong as it will be relative to the next run date of the report).

Related topics