>I want to create a table with a date-stamp name. I tried the following code and I keep getting a "Cannot create file error". Can anyone help me? (I'm using VFP7)
>
>pay_dbf="\data\PR"+RIGHT(DTOS(Date()),6)+".dbf"
>
>Copy file payroll to &pay_dbf
>
>Thanks in Advance
You don't need macro substitution in this case. The name expression will do.
Copy file payroll to (m.pay_dbf)
Does directory '\data\' exist of the root of your current drive SYS(5)?
--sb--