Duration field in Pipeline Outlook channel
Hi, I am creating a pipeline using the Outlook channel to send an email. I have a duration field {{a.days}} in the body of the email that is not coming through correctly. A value of 2 days comes th...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDo you want to come through as an integer number of days? Or could there be fractional days or minutes and hours?
If you have a duration which is really the time span between two date fields then you could make a numeric formula field in native QuickBase called [# of Days]. The formula would be
ToDays([my duration field])
Then use that field in your email.
That large value you are seeing is the number of milliseconds in two days. 60 * 60* 24 * 2 * 1000 = 172800000.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
If you have a duration which is really the time span between two date fields then you could make a numeric formula field in native QuickBase called [# of Days]. The formula would be
ToDays([my duration field])
Then use that field in your email.
That large value you are seeing is the number of milliseconds in two days. 60 * 60* 24 * 2 * 1000 = 172800000.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Creating the formula field worked perfectly! Thank you for your help!
------------------------------
Deb Lanser
------------------------------
------------------------------
Deb Lanser
------------------------------