Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
Jeffery,
If the field type being tested is Duration then you will need ot test against a duration.
If([day 1 time on site] > Hours(4),"TRUE","FALSE")
If the field type being tested is Duration then you will need ot test against a duration.
If([day 1 time on site] > Hours(4),"TRUE","FALSE")
- JeffreyJones16 years agoQrew TraineeThank you! This worked perfectly. I was close, but have a lot to learn about coding.
- QuickBaseCoachD6 years agoQrew CaptainMany new users get tripped up by formuals involving dates and time and durations, especially Durations.
If you look back on your original formula, you will see that Quick base would have no way to know if you meant 4 minutes or 4 hours or 4 days or 4 weeks.
So that is why we needed to convert that 4 to a Duration. - JeffreyJones16 years agoQrew TraineeThanks again. Yes I did see that syntax error, stating it wouldn't work due to the value being a duration, but I couldn't figure out how to get around it. I found the Hours formula you listed, but wasn't using it correctly along with the If function.
The sad part is I'm far from a new user of QB, as I've been using it close to ten years actually, but have only started getting into the coding portion of it the last couple years. But lesson learned and I'll stop spending hours running in circles and ask experts like yourself when I'm stumped going forward.