RE: [sqr-users] sysdate

[Bob Stone <bstone@fastenal.com>]

messed that up. 

let $sysdate1 = substr($sysdate0,1,4)  !The sysdate you just made into a
string...not the original


-----Original Message-----

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