Training FAQ
FAQ Detail
Review the full answer below, then return to the searchable FAQ list.
How do I enter dates? Can the date format be changed?
GamePlanPro™ Date Handling
- Date format is YYYY-MM-DD. Example: 2014-11-25
- Date time format is YYYY-MM-DD HH:MM (24 hour). Example: 2014-11-25 15:30
You may enter a number with a plus or minus prefix to indicate days from or before today:- "+2" will return 2 days from the current date
- "-2" will return 2 days before the current date
- "+0" will return the current date
- "+0 9:30" will return the current date at 9:30am
- "+0 9" will return the current date at 9:00am
You may also enter partial dates:- "21" will return the current year, current month with 21 as the date
- "11-21" will return the current year, with the 11th month, and the 21st day
- "2015-1-3" will return the year 2015, the 1st month, and the 3rd day
- You may enter time along with the short hand date. Example: +2 11:30 or 12-31 23:59
- You may enter time without the ":". Example (seventeen hundred hours): 2017-01-27 1700
- You may enter am/pm. Example: 2017-01-27 5pm. Example: +3 5:30 pm
If the field has been configured to allow an increment relative to another date/time field, you may enter:- "++30" will add 30 minutes to the date/time of the other field
- "++30m" will add 30 minutes to the date/time of the other field
- "++1h" will add 1 hour to the date/time of the other field
- "++1d" will add 1 day to the date/time of the other field