RE: [sqr-users] date format

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

Thanks for all your input. Yeah, we just need patience to get the right one. 
I got it and i used the following:

let $activity_date = 
edit(StrtoDate($activity_date,'YYYYMMDD'),'dd-MON-yyyy')

Thanks again.

>From: "Knapp, Richard" <KnappR@umsystem.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:51:24 -0500
>
>
>And don't know how to handle one when we do get one.
>
>Richard Knapp
>Database Programmer/Analyst
>Institutional Research and Planning
>University of Missouri System
>573-882-8856
>knappr@umsystem.edu
>
>-----Original Message-----
>From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
>[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
>Bob Stone
>Sent: Tuesday, May 10, 2005 10:47 AM
>To: 'This list is for discussion about the SQR database reporting
>languagefrom Hyperion Solutions.'
>Subject: RE: [sqr-users] date format
>
>maybe it's because we're all programmers.  can't get a date...
>
>
>-----Original Message-----
>From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
>[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
>James Womeldorf
>Sent: Tuesday, May 10, 2005 10:37 AM
>To: 'This list is for discussion about the SQR database reporting
>language from Hyperion Solutions.'
>Subject: RE: [sqr-users] date format
>
>
>Are you trying to get $Activity_Date to be a date or a string?
>Perhaps you are having difficulty because of the use of $Activity_Date
>multiple times in your statements.  Sometimes it is supposed to be a
>string
>and sometimes it is supposed to be a date.
>
>It's amazing.  All these nice folks and we all seem to have difficulty
>'getting' dates :)
>
>-----Original Message-----
>From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
>[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
>radhika reddy
>Sent: Tuesday, May 10, 2005 10:26 AM
>To: sqr-users@sqrug.org
>Subject: RE: [sqr-users] date format
>
>
>
>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
>
>_______________________________________________
>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
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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