Hi Glenn;

   Actually, the Date( ) method is working as per is documentation in the PB Help file ..

PowerBuilder attempts to match the input string to a date format in the regional settings on the computer. If a complete match is not found, PowerBuilder attempts a partial match. For example, if you use Date('01-JAN-1900') and PowerBuilder finds the partial match (dd-MMM-yy), PowerBuilder parses the first two numbers of the year and gets 19. The 2-digit year is interpreted as a year between 1930 and 2029, and the date returned is 1/1/2019.

     The key is also the current regional settings. Personally, I never use anything but the ANSI ISO date standard which is CCYY-MM-DD as input to the Date() method. I then rely on the use of Display Masks to show the date externally. On date input, I always force the user to give the Apps the ANSI ISO format by using Edit Masks "CCYY-MM-DD"  so that there is no date ambiguity.

HTH

Regards ... Chris

Yes. Which is why I suggested he try using the "/" date field separators.

Olan

My Setting are identical... yet the Date Function does not produce the correct result.

First check your REGION & DATE settings to see what your platform is using as the DATE format

Control Panel --> Region & Date

If the format is not what you want, then change it.

The call to  Date ("12/31/2012") should return the correct date of 31-DEC-2012.


Olan