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")
JeffreyJones1
6 years agoQrew Trainee
Thanks 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.
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.