You can use the AddToTime function to add hours, minutes, and/or
seconds to time. This function returns the result as a Time value. To
subtract from time, you can simply use negative numbers. The resulting
value
is always adjusted such that it represents an hour less than 24 (example: 18:45)
Syntax
AddToTime(time, hours, minutes, seconds)
So, how does it look like using an example?
¤t_time = 19:20:05. The below code will move the time ahead 1 hr, 5 minutes and 10 sec resulting in 20:25:15
&future_time = AddToTime(¤t_time, 1, 5, 10);
&future_time = AddToTime(¤t_time, 1, 0,0); (only one hr ahead 20:20:05)
&future_time = AddToTime(¤t_time, 1, -5,0); (only one hr ahead and 5 minutes back 20:15:05)
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
Comments
Post new comment