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

Changing Date Format Using PeopleCode

Tue, 08/05/2008 - 5:29am — aryadav
No votes yet

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:
  • Delicious
  • Digg
  • StumbleUpon
  • Reddit
  • Furl
  • Facebook
  • Google
  • Yahoo
  • Technorati
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 2 days 11 hours ago. Offline
Joined: 06/23/2008
Posts: 479
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
  • reply
Thu, 09/02/2010 - 8:13am
#2
gwulfwud's picture
gwulfwud
User offline. Last seen 23 hours 42 min 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
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
5 + 7 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Unanswered Forum Posts

Title Under Posted on
How to run nvision report through portal PeopleSoft Technical 08/31/2010 - 4:45am
Any1 here who can help? PeopleSoft Technical 08/31/2010 - 2:12am
How to create matrix layout PeopleSoft Technical 08/27/2010 - 2:22am
UnCaught C++ Exception PeopleSoft Technical 08/10/2010 - 9:05am
more