Computing time difference

[mssbass]

I need help with creating a query which produces how many minutes or days difference there is between dates formatted as follows:

I need a query (no vba, etc.)

2003-10-07 10:30:00

 

[Golom]

Formatting doesn't matter. All dates are doubles internally.

Select DateDiff("n", [FirstDate], [SecondDate]) As [Minutes], ...

 

[mssbass]

I can't get this to work. Do I just replace the firstdate and seconddate with my table names? what else do I do to this statement? I'm assuming this goes into the "build" area of my select query?

 

[Golom]

Not table names ... field names. I just used [FirstDate] and [SecondDate] as place holders for the two date fields that you said you had. If you're doing this in query design view rather than SQL view then define a field as

Minutes: DateDiff("n", myTable.[FirstDate], myTable.[SecondDate])

Where "myTable" is the name of the table containing the fields.

 

[mssbass]

I need the difference in time to show # of days, hours and minutes left over between the 2 dates??

 

[MichaelRed]

there are NUMEROUS tthreads in these fora with various soloutions. Use search / advanced search. Please use htese resources BEFORE asking (new) questions. It can save both you (the original poster) and the respondents (answerers) time and effort. Further, you may often get several variations on the theme and thus a choice of approaches,



MichaelRed