(date) function giving me error

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


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.