Difference between revisions of "Updating Dates or Times with Pandora"
From SmartWiki
(Created page with 'Dates are stored in the SmartSimple database in the following format: yyyy-mm-dd Accordingly when updating date fields (both standard fields and custom fields) using Pando…') |
|||
| Line 2: | Line 2: | ||
yyyy-mm-dd | yyyy-mm-dd | ||
| − | + | ==Standard Fields== | |
| − | |||
| − | |||
The ''startdate'' and ''enddate'' standard fields also store values for the ''starttime'' and ''endtime'' respectively. Thus you must include the times as well as the dates (if the times are enabled). The format should be: | The ''startdate'' and ''enddate'' standard fields also store values for the ''starttime'' and ''endtime'' respectively. Thus you must include the times as well as the dates (if the times are enabled). The format should be: | ||
| Line 12: | Line 10: | ||
ie: ''2012-01-31 17:30:00'' | ie: ''2012-01-31 17:30:00'' | ||
| + | |||
| + | '''Note''': if you omit the time when updating the '''startdate''' or '''enddate''' standard fields, any times that had been stored in the starttime or endtime will be reset to 00:00:00 | ||
| + | |||
| + | ==Custom Fields== | ||
| + | |||
| + | Accordingly when updating date fields (both standard fields and custom fields) using Pandora the format of the value sent must be '''yyyy-mm-dd''' | ||
| + | |||
Revision as of 17:13, 5 August 2010
Dates are stored in the SmartSimple database in the following format:
yyyy-mm-dd
Standard Fields
The startdate and enddate standard fields also store values for the starttime and endtime respectively. Thus you must include the times as well as the dates (if the times are enabled). The format should be:
yyyy-mm-dd HH:mm:ss
Where HH is the hour using the 24hr format.
ie: 2012-01-31 17:30:00
Note: if you omit the time when updating the startdate or enddate standard fields, any times that had been stored in the starttime or endtime will be reset to 00:00:00
Custom Fields
Accordingly when updating date fields (both standard fields and custom fields) using Pandora the format of the value sent must be yyyy-mm-dd
