Issue with Days Remaining Column Showing Decimal Values in PDF Output

[scotfield123]

I’m experiencing an issue with a column in my Glide table that calculates “days remaining.” The values in the column usually appear as something like “127 days remaining,” which is what I want. However, if I double-click on a cell in the column, the value changes to something like “127.2343732,” which looks like the raw underlying data.

The bigger problem is that when I generate a PDF or share the data, it shows the decimal value (e.g., “127.2343732”) instead of the cleaner “127 days remaining” format.

Is there a way to make sure the displayed format (“127 days remaining”) is locked in and also shown when exporting or printing?

Thanks for your help!

[Darren_Murphy]

How are you calculating the days remaining?

I would use the following in a math column and set the precision to zero decimals:

Trunc(Date-Now)

• where Now is the current date/time, and
• Date is the date of interest