Datediff Cutting Off Decimal Points.

Question

I have a workflow where I calculate the difference between two dates and it will result in decimal places up to 9 decimal places, ie 199.365248361  I have created a formula to do that but when I change the data type to fixed decimal 19.9 it just shows 199.000000000  How can I get it to show correctly?  I've tried change the data types to every option in the select statement but nothing worked.  There are cross tabs and summarizes I need to run using this data and it's throwing off the totals downstream.

I've included a dumbed down but accurate mock up of the section of workflow I'm referencing.

Date Diff Missing Decimal Places.yxmd

echuong1 · Accepted Answer

The rounding is occurring because of the units you've chosen - days. It will round to the nearest whole number. I adjusted the values to be in seconds, and then used a division to get days. This can of course be combined to one formula as well, I separated for clarity.

Hope this helps!

messi007 · Accepted Answer

@knobsdog,

Please see below:

Below the final result:

Hope this helps!

Attached the workflow,

Regards,