Via a simply query, is it possible to select the first Friday after a given date?
Say, if OrderDate is 11/10/2012 or 11/13/2012, then ShipDate would be 11/16/2012, or OrderDate is 11/17/2012, then ShipDate is 11/24/2012?
Thank you!
Via a simply query, is it possible to select the first Friday after a given date?
Say, if OrderDate is 11/10/2012 or 11/13/2012, then ShipDate would be 11/16/2012, or OrderDate is 11/17/2012, then ShipDate is 11/24/2012?
Thank you!
Assuming your Order Date Field is name ODate, in a query in a new field use this expression'
SDate: DateAdd("d",Choose(Weekday([Odate]),5,4,3,2,1,7,6),[ODate])