Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Datediff function with decimals

Hi everyone,   I am using the function Datediff( ), but the results I am getting are integers, and I need than these ones become decimals. Example: Reuslt: 1215 Expected: 1214.7   Any suggesti...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous

    Change date type and format as below:

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous

Change date type and format as below:

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Stevoisiak's avatar
    Stevoisiak
    New Member
    1 year ago

    Does this account for Daylight Savings Time?