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