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

  • 0
  • 1
  • Question
  • Updated 2 years ago

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 future (fid 13):

var text url =

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &

    "&rid=" & [Record ID#] &  "&apptoken=vsiemiczqajhgb9m982fds3fgt4" &

    "&_fid_23="&[Next Sale Date] &

    "&_fid_13="&WorkdayAdd(ToWorkDate(Today()),7)&

    "&_fid_14=0"&

    "&_fid_16=0"&

    "&_fid_17=0";

"javascript:" & "$.get('" & $url & "', function(){" & "location.reload();" &

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}

    "});" & "void(0);"

Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
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))&