P5 Help

 

 

Adjust Dates

 

Adjust Date is a dockable panel that can add to, subtract from, update from another filed, or replace any part of a date/time field. In the example below, all the Event Date values in the active Session will be updated by adding 2 to the hour. This will change the Event Date from 10/19/2013 11:00:00 to 10/19/2013 13:00:00.

 

Field to Update

Select the date field to be updated. The column must be on the active Session grid to be included in the drop-down list.

Records to Update

Select to update all records in the Session or only the selected records.

Operation

Select the operation to perform on the selected component. Choices are Replace, Add, Subtract or Update.

Component

Select the date or time component to update. Choices are Year, Month, Day, Hour, Minute or Second. This field is only available when Update is not the selected Operation.

Value

Enter the value with which to complete the operation. This field is only available when Update is not the selected Operation.