datediff in query

[xeon_tsd]

I am trying to get a datediff in a query between two fields.

DateDiff("d"[MasterServerList].[ScheduleDate],[MasterServerList].[SEReceivedDate])

I have also tried

 DateDiff("d"[MasterServerList]![ScheduleDate],[MasterServerList]![SEReceivedDate])

The rest of the query looks like this and is fine.

SELECT MasterServerList.ServerName, MasterServerList.C_ApplicationID, MasterServerList.Action, MasterServerList.EOL_ActionStatus, MasterServerList.ScheduleDate, MasterServerList.SEReceivedDate, MasterServerList.SEDesignDate
FROM MasterServerList
WHERE (((MasterServerList.Action) Like "Refresh") AND ((MasterServerList.EOL_ActionStatus) Like "Scheduled") AND ((MasterServerList.ScheduleDate)<=#4/30/2014#));

Note that I am calling these same two parameters in the beginning of the query. I want to display the dates and the datediff.

grr =/

[orange]

see this link

[xeon_tsd]

That says to use the above, only with single ticks instead of quotes, which i have also tried to no avail... I have even tried to run this as a new query from the original one. still grrr =/

[ItsMe]

...only with single ticks instead of quotes....

That should do it.
'd'

The other thing is to consider the field that the date is in. Does the query know it is a date field? Is the field in the table data type Date?

[xeon_tsd]

yup the field is a date field.
this is access 2010 if that matters.

meh what am I not seeing?

[ItsMe]

I would expect the following to work by placing it in a new field as an alias

MyAlias: DateDiff('d'[MasterServerList].[ScheduleDate],[MasterServerList].[SEReceivedDate])

and the resulting SQL should read something like

MasterServerList.SEDesignDate, DateDiff('d'[MasterServerList].[ScheduleDate],[MasterServerList].[SEReceivedDate]) AS MyAlias FROM MasterServerList

[June7]

Missing a comma:

DateDiff("d",[MasterServerList]![ScheduleDate],[MasterServerList]![SEReceivedDate])