Use the MONTH(), DAY(), YEAR() functions instead.

HTH

Dan

>I am running into an error trying to parse out the numbers from a date.
>My ulimate goal is to get the number 10042001 from 10/04/2001.
>my code:
>
>mydate = date()
>myfile = substr(alltr(str(mydate)),1,2)
>myfile = myfile + substr(alltr(mydate),4,2)
>myfile = myfile + substr(alltr(mydate),7,4)
>
>Can anyone point me in the right direction where I could solve this problem?
>Thanks >> Wes