Hi guys, I understand that i can do that by using DATEADD function, but i am thinking if there is other way out? Below is my report, I would like to have both the delivery date to show 7 days in advance.
I would use Code: DateAdd("d", -7, Date) but you could use Code: Date() - 7
DateAdd("d", -7, Date)
Date() - 7
Originally Posted by ssanfu I would use Code: DateAdd("d", -7, Date) but you could use Code: Date() - 7 I try and it work! thanks
View Tag Cloud
Forum Rules