RE: [sqr-users] sysdate

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

let $year = edit($sysdate, 'yyyy')



-----Original Message-----
From: Bob Stone [mailto:bstone@fastenal.com]
Sent: Tuesday, October 26, 2004 8:53 AM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] sysdate


If you're getting '2004-10-25' in $sysdatetime_YMD, then substring should
work.  Possibly cast it to a string before doing the substring?

 let $sysdate0 = to_char($sysdatetime_YMD)
 let $sysdate1 = substr($sysdatetime_TMD,1,4)
 display 'SYSDATE' $SYSDATE1


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
radhika reddy

How to get just the year from $sysdate in sqr? I tried the following:-

  move '1' to $year4
  move '-' to $DDelimiter
  do Format-datetime($sysdatetime,$sysdatetime_YMD, {DEFYMD}, '', '')
here I am getting 2004- 10-25
   display $sysdatetime_YMD
LET $SYSDATE1 = SUBSTR($sysdatetime_YMD,1,4)
  DISPLAY 'SYSDATE' $SYSDATE1
         but here when I do substring I am getting 0.000000E+00


Can anybody tell me how to get just the year 2004 .


thanks

_______________________________________________
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