0

Formula Field for Date Calculation showing time as well

I've created a Formula field to determines the "Days until Date" which is working great however the output include the time could down as well "18 Days 14:23:00.389" and how do I format this to only show the days until and not include the time? The Number format field doesn't seem to work so not sure how to go about this.

2 replies

null
    • Alain_Fontaine
    • 4 yrs agoSat, October 24, 2020 at 8:51 PM UTC
    • Reported - view

    There is a "days()" (with "s") for this very purpose.

    • Holly_M
    • 4 yrs agoTue, October 27, 2020 at 2:02 AM UTC
    • Reported - view

    I ended up using the format function but in the end it worked