[rivekm]

I am trying to find out how many days between two dates?? I have tried:
in query design I have tried

field: transaction date
field: date case received

expression:[transaction date] - [date case received]

what is the criteria supposed to be?

they are date formats: mm/dd/yyyy

03/15/2007 - 02/15/2007 = how many days between dates???

[Advertisements]

Hello rivekm,

In Access, in query design, go to View | SQL View. Use the following function to get what you need:

DateDiff('d', [date case received], [transaction date])

This function will return the difference between the two dates, in the given increment (d=days). You can search Access help if you want a more thorough explanation.

So your ending SQL statement may look something like the following:

SELECT CaseId, [transaction date], [date case received], DateDiff('d', [date case received], [transaction date]) AS [Case Duration]
FROM Case
WHERE ...

Note: You would not need to include [transaction date] and [date case received] in the return fields, I just included them for reference.

Let me know if this helps,

Ax

[Ax238]

Hello rivekm,

In Access, in query design, go to View | SQL View. Use the following function to get what you need:

DateDiff('d', [date case received], [transaction date])

This function will return the difference between the two dates, in the given increment (d=days). You can search Access help if you want a more thorough explanation.

So your ending SQL statement may look something like the following:

SELECT CaseId, [transaction date], [date case received], DateDiff('d', [date case received], [transaction date]) AS [Case Duration]
FROM Case
WHERE ...

Note: You would not need to include [transaction date] and [date case received] in the return fields, I just included them for reference.

Let me know if this helps,

Ax