>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

If the file you are copying is closed, this is the syntax you want:

lcPay_Dbf = "\data\PR"+RIGHT(DTOS(DATE()),6)+".dbf"

COPY FILE payroll.dbf TO (lcPay_Dbf)

Note that the extension must be included, and that this only copies the .dbf, not the .cdx or .fpt. Those have to be copied separately.

If the file is open, this is the syntax you want:

lcPay_Dbf = "\data\PR"+RIGHT(DTOS(DATE()),6)+".dbf"

SELECT payroll
COPY TO (lcPay_Dbf)

This includes all relevant files (.fpt and .cdx).