Sunday, February 7, 2010

Convert String to Date in PeopleCode

DateValue(string)

This method is used to convert the date in string format to the date format.

Example

If the user's Date Format personalization setting is set to DDMMYY

&DATE = DateValue("10/09/10");
would return a value equal to September 10, 2010.

If the user's Date Format personalization setting is set to MMDDYY

&DATE = DateValue("10/09/10");
would return a value equal to October 9, 2010.

No comments: