arasj3827

(date) function giving me error

Discussion created by arasj3827 on Nov 25, 2011
Latest reply on Nov 25, 2011 by LyndsayHowarth

Help...

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.

Outcomes