[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Date Format : Help

There are easier ways...

Try edit function

Let $last_date_time =  edit($last_date_time,'MM/DD/YYYY')

Or edit mask:

Print $last_date_time    (  ,{Col6}) edit 'MM/DD/YYYY'




Bruce


-----Original Message-----
From: Andalib Yussuf [mailto:andalib.yussuf@AMS.COM]
Sent: Friday, August 23, 2002 10:53 AM
To: SQR-USERS@list.iex.net
Subject: Date Format : Help


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