Using Criteria for Formatted DateDiff Value

[PaulA]

Hi, all -

I've successfully (with help of this forum) created a DateDiff calculation that is generated with a d:h:nn format. Now the question:

How can i select or identify specific values, such as <= 2 days using those outcomes generated by the expression? Is it possible?

Example: a value is generated as 3:14:35. I would want to indicate this more than two days by putting a "N" in a separate column.

How is this done?

Thanks.

 

[CJ_London]

you need to clarify what you mean - 3:14:35 says to me that it is nearly quarter past three in the morning - so more than 2 days since what?

 

[spikepl]

That is not a formatted datediff calculation (because access will never itself calculate anything in expressed in days:hours:minutes), but a textstring.

SO using the text functions http://www.techonthenet.com/access/functions/ you can find the location of the first ":" and all that precedes it a number to be used for your criterion.

 

[PaulA]

Thanks for your responses.

Spikepl, I'll try your suggesion.