This question is a little embarrassing since I have been writing
code for years but here goes. I am using a function that requires
the date to be passed in MMDDYYYY format Long integer. The
the function converts the long integer to a julian date. My problem
is this.
The problem is 08092001 is returned as yes... 8092001 and I'm
missing the 0 infront of the eight. I have searched and searched
but can't find what should be a simple solution. I know that the
VAL is the problem but does anyone know how I can keep the leading
zero?
Red Faced in PA
------------------
code for years but here goes. I am using a function that requires
the date to be passed in MMDDYYYY format Long integer. The
the function converts the long integer to a julian date. My problem
is this.
Code:
TDate=Date$ Replace "-" with "" in TDate Date=Val(TDate)
missing the 0 infront of the eight. I have searched and searched
but can't find what should be a simple solution. I know that the
VAL is the problem but does anyone know how I can keep the leading
zero?
Red Faced in PA
------------------
Comment