{"id":54,"date":"2016-09-21T15:27:43","date_gmt":"2016-09-21T03:27:14","guid":{"rendered":"http:\/\/help.psoda.com\/?page_id=54"},"modified":"2024-03-07T00:45:24","modified_gmt":"2024-03-07T00:45:24","slug":"a6","status":"publish","type":"page","link":"https:\/\/www.psoda.com\/help\/a6\/","title":{"rendered":"Date formats"},"content":{"rendered":"

Date field and formats<\/h3>\r\nThis 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<\/a>editable user preferences<\/a>. 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.\r\n\r\nBelow are some alternative date formats that you can try:\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Format<\/th>\r\nExample<\/th>\r\n<\/tr>\r\n
dd-mm-yyyy<\/td>\r\n24-02-2008<\/td>\r\n<\/tr>\r\n
dd\/mm\/yyyy<\/td>\r\n24\/02\/2008<\/td>\r\n<\/tr>\r\n
ddmmyyyy<\/td>\r\n24022008<\/td>\r\n<\/tr>\r\n
yyyy-mm-dd<\/td>\r\n2008-02-24<\/td>\r\n<\/tr>\r\n
yyyy\/mm\/dd<\/td>\r\n2008\/02\/24<\/td>\r\n<\/tr>\r\n
yyyymmdd<\/td>\r\n20080224<\/td>\r\n<\/tr>\r\n
yy-mm-dd<\/td>\r\n08-02-24<\/td>\r\n<\/tr>\r\n
dd mmm yyyy<\/td>\r\n24 Feb 2008<\/td>\r\n<\/tr>\r\n
dd month yyyy<\/td>\r\n24 February 2008<\/td>\r\n<\/tr>\r\n
+\/- # months\/weeks<\/td>\r\n+3 months<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

Date picker<\/h3>\r\nYou can use the date picker by clicking the \"Calendar 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.\r\n

Dropdown options<\/h3>\r\nIf 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<\/b> 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).<\/div>\r\n

Related topics<\/h4>\r\n