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
editable 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:
Format | Example |
---|
dd-mm-yyyy | 24-02-2008 |
dd/mm/yyyy | 24/02/2008 |
ddmmyyyy | 24022008 |
yyyy-mm-dd | 2008-02-24 |
yyyy/mm/dd | 2008/02/24 |
yyyymmdd | 20080224 |
yy-mm-dd | 08-02-24 |
dd mmm yyyy | 24 Feb 2008 |
dd month yyyy | 24 February 2008 |
+/- # months/weeks | +3 months |
Date picker
You can use the date picker by clicking the
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).