Ask Question
Help Others
Home › PeopleSoft › PeopleCode › Built-in Functions

Changing Date Format Using PeopleCode

Tue, 08/05/2008 - 5:29am — aryadav
Your rating: None Average: 3.9 (11 votes)

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
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
  • Login to post comments
  • 107362 reads
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!

Comments

Have a question? Please ask it on the forum instead.
Fri, 08/29/2008 - 3:09pm
#1
Lepa's picture
Lepa
User offline. Last seen 23 weeks 6 hours ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Changing Date and Date time formate example

Here is an example on how we can apply the above function.

%date in as 2008-08-29 out as 20080829:

&date = DateTimeToLocalizedString(%Date, "yyyyMMdd");

%Datetime in as 2008-08-19-17.12.09.000000 out as 20080828-171209:

&datetime = DateTimeToLocalizedString(%Datetime, "yyyyMMdd-HHmmss");

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

Top
Thu, 09/02/2010 - 8:13am
#2
gwulfwud's picture
gwulfwud
User offline. Last seen 8 years 29 weeks ago. Offline
Joined: 05/07/2009
Posts: 7
Re: Changing Date Format Using PeopleCode

So I have a question.

I've been trying to get the year from a date value.

&LastDateWorkedYear = &rs1(&I).TIA_VW.LAST_DATE_WORKED.Value;
&LastDateWorkedYear = Year(&LastDateWorkedYear);

I get this error:

An invalid date has been encountered in a PeopleCode program.

Top
Fri, 09/03/2010 - 11:57am
#3
Hari_aindian's picture
Hari_aindian
User offline. Last seen 5 years 5 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: Changing Date Format Using PeopleCode

Are you sure that the &LastDateWorkedYear has a valid date?

Year(DATE) function will work only if the provided DATE is a vaild date format. If it is a Date time field then it wont work. Or else declare &LastDateWorkedYear as date and then try.

pls do let me know which one resolves your issue.

Regards,
Hari.A

Top