Discussions

  • 1.  Duration field in Pipeline Outlook channel

    Posted 24 days ago
    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 through as 172800000.  Any ideas on how to have it display correctly?

    Thanks,
    Deb

    ------------------------------
    Deb Lanser
    ------------------------------


  • 2.  RE: Duration field in Pipeline Outlook channel

    Posted 24 days ago
    Edited by Mark Shnier (YQC) 23 days ago
    Do 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
    ------------------------------



  • 3.  RE: Duration field in Pipeline Outlook channel

    Posted 23 days ago
    Creating the formula field worked perfectly!  Thank you for your help!

    ------------------------------
    Deb Lanser
    ------------------------------