User login
Sponsored links
Changing Date Format Using PeopleCode
Tue, 08/05/2008 - 5:29am — aryadav
Peoplesoft provides a function called as "DateTimeToLocalizedString" to change date from one format into another.
Following is syntax used to achiev this.
DateTimeToLocalizedString({datetime | date}, [Pattern])
Param1 : Variable of Date Datatype
Param2 : Date format which you want for example "dd/MM/yyyy".
If you have Param1 of type string then use function "DateValue" to convert that string to Date.
Bookmark/Search this post with:
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| Regarding Error "SQR 6002) CANNOT OPEN THE PRINTER FILE: " in SQR | PeopleSoft Technical | 11/21/2008 - 1:17am |
| Pay calendar Setup | PeopleSoft Functional | 11/18/2008 - 5:30pm |
| Issue linking to Excel 2007 from PS HRMS 8.8 | PeopleSoft Technical | 11/17/2008 - 9:48am |
| Spreadsheet-Based Control System Analysis and Design | Programming | 11/11/2008 - 5:10am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
About aryadav
Job title
Peoplesoft Developer
Comments
Re: Changing Date and Date time formate example
Join date: 06/23/08
Here is an example on how we can apply the above function.
%date in as 2008-08-29 out as 20080829:
%Datetime in as 2008-08-19-17.12.09.000000 out as 20080828-171209:
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Post new comment