RE: [sqr-users] date format

["radhika reddy" <radhika_05@hotmail.com>]

yes, i tried and i get the following error:

(SQR 4008) Unknown function or variable in expression: to_date
let $activity_date = to_date($activity_date,'dd-mon-yyyy')

thanks.

>From: "Lindquist, Maria" <mlindqui@uwc.edu>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] date format
>Date: Tue, 10 May 2005 10:11:43 -0500
>
>Did you try the following at all?
>
>Let $Activity_Date = TO_DATE($Activity_date,'dd-mon-yyyy')
>
>Maria
>
>-----Original Message-----
>From: sqr-users-bounces+mlindqui=uwc.edu@sqrug.org
>[mailto:sqr-users-bounces+mlindqui=uwc.edu@sqrug.org] On Behalf Of
>radhika reddy
>Sent: Tuesday, May 10, 2005 10:02 AM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] date format
>
>Hi,
>
>    I always have tough time to format dates. This time the date that I
>get from a flat file is in 'YYYYMMDD' format. However i do it i get
>errors.
>
>I tried doing something like this:-
>
>Let $activity_date = edit($activity_date, 'dd-mon-yyyy')
>
>or
>
>let $activity_date = to_char(to_date($activity_date, 'YYYYMMDD'),
>'dd-MON-yyyy')
>and
>
>let $activity_date =
>Datetostr(StrtoDate($activity_date,'YYYYMMDD'),'dd-MON-yyyy')
>
>and
>
>begin-select on-error=print-date-error
>to_char(to_date($activity_date, 'MM/DD/YYYY'), 'dd-MON-yyyy')
>&activitydate
>   move &activitydate to $activity_date
>from dual
>
>Any idea where i am going wrong on this?
>
>Thanks.
>
>_________________________________________________________________
>Is your PC infected? Get a FREE online computer virus scan from
>McAfee(r) Security.
>http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users