>>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)

Sergey,

Yeah, but it depends on the MM/DD/YYYY date format, doesn't it? If so, I'd think that using the DAY(), MONTH() and YEAR() functions might be better.