No results using DateDiff

[Martha]

I am working with DateDiff . I get no error messages but also do not get any
results in my calculated field. I have two dates, START_DATE and END_DATE and
I need to know the number of days between them. START_DATE and END_DATE are
both Date/Time type with a Short Date format.

I am working in the QBE grid to write the query. I select an empty column
and put my DateDiff calculation on the line below Or: in the Criteria area. I
have tried:

[END_DATE]-[START_DATE]
and
DateDiff("d",[START_DATE],[STOP_DATE])

Both approaches ask for parameter values for Time and STOP_DATE. If I don't
enter anything the query runs and displays data from all other columns,
displays the calculated field, Time, but the cells are empty.

Help is appreciated, and I expect to feel pretty stupid after I get it!

 

[Jeff Boyce]

Martha

Is there any significance to your use of both [END_DATE] and [STOP_DATE]?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Klatuu]

Create a calculated field in your query:

TotDays: DateDiff("d",[START_DATE], [END_DATE])

Not in the criteria rows.

 

[Martha]

Thanks, Klatuu. As this is my first post, could you let me know how to mark
this thread as answered?

Martha

Create a calculated field in your query:

TotDays: DateDiff("d",[START_DATE], [END_DATE])

Not in the criteria rows.
--
Dave Hargis, Microsoft Access MVP

I am working with DateDiff . I get no error messages but also do not get any
results in my calculated field. I have two dates, START_DATE and END_DATE and
I need to know the number of days between them. START_DATE and END_DATE are
both Date/Time type with a Short Date format.

I am working in the QBE grid to write the query. I select an empty column
and put my DateDiff calculation on the line below Or: in the Criteria area. I
have tried:

[END_DATE]-[START_DATE]
and
DateDiff("d",[START_DATE],[STOP_DATE])

Both approaches ask for parameter values for Time and STOP_DATE. If I don't
enter anything the query runs and displays data from all other columns,
displays the calculated field, Time, but the cells are empty.

Help is appreciated, and I expect to feel pretty stupid after I get it!

 

[Michel Walsh]

It is enough, already, that you simply mentioned it ! You would be
surprised to see how many posters don't even take time to give even that
kind of simple feed-back ! Thanks to you to do it.


Vanderghast, Access MVP

 

[Martha]

Jeff,
No significance except to demonstrate that my head is not always directing
my fingers. They should have been the same.
Martha

Martha

Is there any significance to your use of both [END_DATE] and [STOP_DATE]?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am working with DateDiff . I get no error messages but also do not get
any
results in my calculated field. I have two dates, START_DATE and END_DATE
and
I need to know the number of days between them. START_DATE and END_DATE
are
both Date/Time type with a Short Date format.

I am working in the QBE grid to write the query. I select an empty column
and put my DateDiff calculation on the line below Or: in the Criteria
area. I
have tried:

[END_DATE]-[START_DATE]
and
DateDiff("d",[START_DATE],[STOP_DATE])

Both approaches ask for parameter values for Time and STOP_DATE. If I
don't
enter anything the query runs and displays data from all other columns,
displays the calculated field, Time, but the cells are empty.

Help is appreciated, and I expect to feel pretty stupid after I get it!