DateDiff function

[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?

 

[fredg]

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?

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

 

[thebrat26]

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

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?

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