get result from arithmetic operation with leading zeroes

Julie Maquirang · Posted: Mon Mar 02, 2009 3:16 pm

Hi,

Does anybody knows how to get result from arithmetic operation with leading zeroes

I am getting the current date with Julian date format
when I subtract 1 from my variable(julian date)

CDATE = 09061

CDATEB=CDATE-1

result:

CDATE=9060

Julie Maquirang · Posted: Mon Mar 02, 2009 3:20 pm

Correction:

result:

CDATEB=9060

Garry Carroll · Posted: Mon Mar 02, 2009 3:29 pm

Use the RIGHT function.

gcicchet · Posted: Mon Mar 02, 2009 3:36 pm

Hi,

what happens when julian date is equal to 09001 ?

Gerry

Julie Maquirang · Posted: Mon Mar 02, 2009 3:39 pm

Hi Gerry,

Thanks!!

Julie Maquirang · Posted: Mon Mar 02, 2009 3:40 pm

I haven't tried yet... =)