Answered

calculate how many days the sharepoint file was created

(0) Share

Report

Posted on by jurunas2023

102

Eu preciso calcular quantos dias o arquivo do sharepoint foi criado, o que eu pensei que era para usar a função utcnow() - data de criação do arquivo do sharepoint. Mas como fazer essa conexão?

Categories:

Business Process Flows

All responses (3)

Answers (1)

Verified answer

Expiscornovus 31,648 Most Valuable Professional on at

Like (1)

Report
Re: calculate how many days the sharepoint file was created

Hi @jurunas2023,

That is -2 days. So, if you only want the days you should be able to use a split function for that (with a split on the dot character).

split(dateDifference(outputs('Get_file_properties')?['body/Created'],utcNow()), '.')[0]
jurunas2023 102 on at

Like (0)

Report

Re: calculate how many days the sharepoint file was created

Now, how do you convert the function value to days?
For example: the date created is 2022-12-28T20:27:50.000000Z and today's date as end gives the following number -2.01:16:29.7916441
Expiscornovus 31,648 Most Valuable Professional on at

Like (1)

Report
Re: calculate how many days the sharepoint file was created

Hi @jurunas2023,

You could use an expression with a dateDifference function for this.

dateDifference('<startDate>', '<endDate>')

Below is an example

dateDifference(outputs('Get_file_properties')?['body/Created'],utcNow())