0
edits
Changes
no edit summary
Dates are stored in the [[SmartSimple]] database in the following format:
Accordingly when updating date fields with Pandora the submitted data must be formatted identically.
==Standard Fields==
The ''startdate'' and ''enddate'' standard fields [[Standard Fields]] also store time 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:ssSimilarly with ''lastmodified'' (although there is no associated ''lastmodifiedtime'' variable).
Example:
2012-01-31 17:30:00
'''Notes:'''
* If you omit the time when updating the ''startdate'' or ''enddate'' standard fields, the stored in the ''starttime'' or ''endtime'' will be set to 00:00:00, overwriting any times that may have been stored previously.
* The '''Level 1''' Start Date and End Date fields are referred to as '''ostartdate''' and '''oenddate'''
* The Level 1 ''closedate'' standard field does '''not''' store a time so should be updated using '''yyyy-mm-dd''' only.
* The ''lastmodified'' standard field on transactions is ''trsts''
==Custom Fields==
When updating Date [[Custom Fields]] using Pandora the format of the value sent must be '''yyyy-mm-dd'''.
* Times cannot be saved with Date Custom Fields.
==See Also==
* [[Manipulating Dates]]
* [[Pandora - Sample - Update Multiple Level 2 Records Associated with a Level 1]]
[[Category:Pandora]]
