Format Date Compose adding to date

(0) Share

Report

Posted on by jessicabishop47

Hi,

I have built a flow to go off when a sharepoint item is modified.

In the flow, I would like to subtract one date from another to get a number of days.

To do this, I have put the modified date and report date into compose actions and set the expressions as formatdatetime((composeitem),'dd/MM/yyyy').

When I test it, for some reason it spits out the date with months added in.

Does anyone know how I can fix this?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Re: Format Date Compose adding to date

To find the days between two dates you would get the number of ticks for each date, subtract one from the other, then divide by 864000000000. See example below that subtracts the Modified date from the current date to find out the days between. You would just need to replace utcNow() with your Report date.

div(sub(ticks(utcNow()), ticks(triggerOutputs()?['body/Modified'])), 864000000000)

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
jessicabishop47 71 on at

Like (0)

Report

Re: Format Date Compose adding to date

Hi @grantjenkins

Thanks for that. My main concern was for the months being added to the formatted date. Can you help with that?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Re: Format Date Compose adding to date

Can you show your exact formula you've used to format the date? You should have something like:

formatDateTime(outputs('modified'), 'dd/MM/yyyy')

Was this reply helpful? Yes No
Verified answer

jessicabishop47 71 on at

Like (0)

Report

Re: Format Date Compose adding to date

This is the formula used:

formatDateTime(outputs('modified'),'dd/mm/yyyy')

Was this reply helpful? Yes No
jessicabishop47 71 on at

Like (1)

Report

Re: Format Date Compose adding to date

I think I've just found that it was taking the minutes value from the datetime.

Is that formula correct?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

Re: Format Date Compose adding to date

Lowercase m refers to minutes, while uppercase M refers to month. You should have 'dd/MM/yyyy'.

If you look at the modified date, the minutes are 09 which is what's coming up as your months since you used lower case m.

Was this reply helpful? Yes No
jessicabishop47 71 on at

Like (0)

Report

Re: Format Date Compose adding to date

I just saw that, thank you. I think I got confused because I had seen that before, and changed it but I must not have saved it 🥴. Thanks for your help.

Was this reply helpful? Yes No