Hey folks,
I would like to use the Datediff() function to do the below (which works) but I would like to add a twist but have yet to solve.
IIf(DateDiff("m",[tblService2].[CompletionDate],Now())>3,"Yes","NO")
What I'm hoping to do is do the above but have it "do something" a week before the 3 months are reached. So, I thought of the ww interval but that could get messy as I would like to keep the month interval.
I've not yet started testing with the ww to see how it actually works but I assume it counts the # off weeks between date1 and date2.