Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Formula Help
- Thread starter wanzek
- Start date
briangriffin
Programmer
This should do the trick:
if day({Orders.Order Date}) = 1 then {Orders.Order Date}
else
DateAdd ('m' , 1 , {Orders.Order Date} - day({Orders.Order Date}) + 1)
Check out Ken Hamady's site - there are a lot of useful formulas there, so you don't have to remember them all.
if day({Orders.Order Date}) = 1 then {Orders.Order Date}
else
DateAdd ('m' , 1 , {Orders.Order Date} - day({Orders.Order Date}) + 1)
Check out Ken Hamady's site - there are a lot of useful formulas there, so you don't have to remember them all.
- Status
Similar threads
- Locked
- Question