Changes

Jump to: navigation, search

Updating Dates or Times with Pandora

589 bytes added, 19:15, 10 April 2013
no edit summary
Dates are stored in the [[SmartSimple]] database in the following format:
'''yyyy-mm-dd'''
 
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).
Where The format should be:'''yyyy-mm-dd HH is the hour using the 24hr format.:mm:ss'''
ie: ''2012-01-31 17:30:00''* Where HH is the hour using the 24hr format.
'''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==Example: 2012-01-31 17:30:00 
Accordingly '''Notes:'''* If you omit the time when updating date fields (both 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 custom 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 Pandora the format of the value sent must be '''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]]
0
edits

Navigation menu