Forum Discussion

Qrew Captain

5 years ago

Adding duration to date / time field

This seems like it should be simple, but I can't get the formula to work. I have a date / time field. I have a duration field that is numeric. I have a formula date / time field. I want to ente...

Formulas and functions

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

try this

[my date / time field] + Hours([my hours field])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

ChrisNewsome
Qrew Captain
5 years ago
Dang it Mark, I knew I was making it too difficult. It was the Hours phrasing before the duration that I was missing.

Thanks as always!

------------------------------
Thanks,
Chris Newsome
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  right, when you have a date time field you need to be adding a duration to it and not a number as the system does not know if that would be seconds, minutes, hours, days or weeks to add.
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - DirkRuana
    Qrew Captain
    5 years ago
    Hi Mark:
    
    I am having a similar problem:
    
    [Date Created]+Days([Response Time Record - Response Duration])
    
    [Date Created] is Date/Time field
    [Response Time Record - Response Duration] is a duration field
    
    I am still receiving this error message:
    
    Any ideas what I am doing wrong? I've tried everything I can think of.
    
    Thank you,
    
    Dirk
    
    ------------------------------
    Dirk Ruana
    ------------------------------