2

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula:

=DATEDIF([Column 1],[Column 2],"D")

But when i trigger the calculated column in a flow and show the days calculated in an email it look likes for example: Image


So what i should use in the formula to remove all the zeros ? Any help would be appreciated.

Thank you!

  • What are your settings on the calculated field? Is it returning a number? And if so with how many decimals? – Johan Brännmar Nov 7 at 11:08
  • Yes in my list it's returning number without zeros, in the email it shows the zeros no idea why.Take a look here in my list: i.imgur.com/v4lslQd.png @JohanBrännmar – SmithBZ Nov 7 at 11:15
1

Use the formula.

int(triggerBody()?['DateDif'])

enter image description here

2

This question might help. The accepted answer says to just put your current column formula inside ROUND:

=ROUND([your formula here],0)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.