Forum Discussion

KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
9 years ago

How do I create a formula that moves the date/time 7 days ahead?

Kirk Trachy helped me with this formula today, but one part I left out is that the the date field was actually a date/time field, so I also need the exact time to be represented one week into the fut...
APIs and custom code
Formulas and functions
Tables and fields
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
Because you are dealing with a date time, and QuickBase doesn't have an "AdjustWeek" formula.  You can add the number of hours in a week.

24 hours x 7 days = 168 hours.  
And you can use the "Now()" option to use the current date / time. 
Combine that to be 

"Now()+Hours(168)"
So you can change you fid_13 line to be 

"&_fid_13="&(Now()+Hours(168))&