Cannot substract two dates values in flow.

[walteroa]

sorry if my question is too basic, but im newbie.

Issue: I need to substract 2 dates that come in UTC format (i guess using RFC3339).

Context: I have 2 dates from Planner that goes to an HMTL table, but I coudnt find the way to calculate the days past between them:

Date#1: 2020-09-21T20:57:09.5169918Z

Date#2: 2020-10-11T08:41:19.3174429Z

i've tried using ticks function, without any result. I also tried "SubtractFromTime" os symply sub function without any results.

is there any date& time action block or function to deal with this basic issue?

I'm really lost in the desert 😞

Thx in advance

[CFernandes · Accepted solution]

Hey @walteroa 

Please try this - https://powerusers.microsoft.com/t5/Building-Power-Apps/how-to-get-difference-between-two-dates-in-f... 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[rathour007]

Can you pls try the approch , explained in this thread

https://powerusers.microsoft.com/t5/Building-Power-Apps/how-to-get-difference-between-two-dates-in-f... 

[walteroa]

Thx @CFernandes and @rathour007

I've tried. Unfortunately no success. I think I have something wrong...

The ticks are not working to me when I pass the UTC string in order to convert to integer.

rationale: 

a) variable string "CreationDate" comes from planner in UTC format

b) variable string "Now" using utcnow()

to substract >>   DiffAsMinutes=Now-CreateDate  seems to be string instead of integer

 

Then, as a result, the output from DiffAsMinuts comes up with string instead of integer. hence error to setup the variable with does not allow to receive an string.

[walteroa]

[yashaikh]

Have you tried int(outputs('EndTimeTickValue')) and int(outputs('StartTimeTickValue')) to convert the values in integer?

[ajdhingr]

@walteroa your issue still exists ?

[walteroa]

Little update: perhaps a sintax error on DiffAsMinutes expression.

Already solved:

[walteroa]

nope. Already solved. Thx!