DateDiff function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I'm using this expression : =DateDiff([m],Date(),[Datehired])
to get the number of months betweem today and the date employees were hired
and it returns #Name?

What is wrong with the expression?
 
Hello,
I'm using this expression : =DateDiff([m],Date(),[Datehired])
to get the number of months betweem today and the date employees were hired
and it returns #Name?

What is wrong with the expression?
Click to expand...

=DateDiff("m",[Datehired],Date())
 
Hi,

I'm having the same problem with Expression Builder

=DateDiff("d",[SubDueDate],Date())

I've tried changing it to [MemberSubs]![SubDueDate] and still get #Name?.
I even tried to create a query for this and other problems I have encountered
- some have worked in the query but then when I use it from a form I get the
same error again.

This is SO frustrating! Can someone tell me what I am doing wrong? Is
there a difference in the way code is written in Queries and in Expression
Builder?

Thanks in anticipation.

T

fredg said:
Hello,
I'm using this expression : =DateDiff([m],Date(),[Datehired])
to get the number of months betweem today and the date employees were hired
and it returns #Name?

What is wrong with the expression?
Click to expand...

=DateDiff("m",[Datehired],Date())
Click to expand...
 
Back
Top