Calculate Age (Days) based upon another Date in the past using ticks produces an Error

Like (0) Share

Report

Posted on 17 Dec 2021 09:16:33 by Lorem1960

379

I am in need to create the Age in Days based upon in my case the Date of Debt. For that I created a flow that loops through all of my items coming from a SharePoint list. Created a variable named DaysSinceDateDebt and I am using this expression:

div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks(outputs('Get_item')?['body/DateofDebt'])),864000000000)

In my Update Item action I have put the following:

When I test the flow I get the following error:

Does anyone has any idea what I am doing wrong here?? Thanks for any advise.

All responses (1)

Answers (0)

mahoneypat 1,720 on 17 Dec 2021 at 12:52:54

Like (0)

Report

Re: Calculate Age (Days) based upon another Date in the past using ticks produces an Error

Your syntax to get calculate age in hours looks correct (checked it with a hard-coded date), but it looks like your date column is coming in as an integer. I would use just that part of your expression to see the value. You may need to use addDays('1899-12-30', <your date value>) to convert it to a date first.

Pat