Im trying to get the following to work in a new calc field (result as text):
"38" & year(date)&month(date)&day(date) &get(recordnumber). I get the following error:
(date) table (or field...dont remember) not found.
The only workaround I found was to create date field with get(currentdate) which then allowed the calc to work.
Am I wrong...isnt (date) a unifersal function? The (date) works fine in a different table I have.