Working days expression in my Form

[lordgeeuk]

Hi I have a Text box that stores a date of when a problem or query is received on to a customer account, when resolved the date it is resolved is inputted in the next text box as a resolved date. My third Text box then needs to display Yes or No depending if it took less than 28 days to resolve.

Ive used a Text box and DateDiff expression to work out the ammount of days in the control source, Called query dauration then a macro to test if its less than 28 days to display the yes or no. But this is not working days Mon - Fri. Has any one any ideas?

=DateDiff("d",[Date Query Raised],[Date Query Resolved])



Macro

IIf([Query Duration]<="28","Yes","No")

 

[lordgeeuk]

Ive tried using w like it suggests but it doesnt seem to be calculating weekdays but weeks, but weeks is suppose to be ww.

=DateDiff("w",[Date Query Raised],[Date Contacted Customer])