Changes

Jump to: navigation, search

Updating Dates or Times with Pandora

132 bytes added, 19:15, 10 April 2013
no edit summary
'''yyyy-mm-dd HH:mm:ss'''
* Where HH is the hour using the 24hr format. 
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.
 
==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 ''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''
==See Also==
* [[Manipulating Dates]]
* [[Pandora - Sample - Update Multiple Level 2 Records Associated with a Level 1]]
[[Category:Pandora]]
0
edits

Navigation menu