>Ohh, the coorrect syntax os like this:
>

lcFilename = 'ex'+right(allt(str(year(date()))),2);
>+allt(str(month(date())))+allt(str(day(date())))
>messagebox(lcFilename)
>select mycursor
>copy to &lcFileName

Hi Chaim,

There's no need to use macro substitution and expression to build file name could be simlified. You can combine the first two lines if you wish.

lcDate = DTOS(DATE())
lcFileName = "ex" + SUBSTR(lcDate,5,4) + LEFT(lcDate,4)
copy to (lcFileName)