Date Format : Help

[Andalib Yussuf <andalib.yussuf@AMS.COM>]

Hello all,
I need some help converting my date to 'MM/DD/YYYY' fprmat.  So far I have
tried using an edit mask and datetostr. The code is provided below. Any
help in this matter would be greatly appreciated.

Thank You


Andalib



Current code:

let $last_date = datetostr($last_date_time,'MM/DD/YYYY') - I get the
following error

Error on line 128:
   (SQR 1944) The date '08/22/2002' is not in the format
specified by SQR_DB_DATE_FORMAT or in one of the accepted
formats listed below:
        DD-MON-YY
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]


is there a way I can set the sqr_db_date_format in my code to what I want
(MM/DD/YYYY)

Any help is appreciated