Unanswered

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:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 33,183 Most Valuable Professional on at

Like (1)

Report
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())

Was this reply helpful? Yes No
jurunas2023 102 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,183 Most Valuable Professional on at

Like (1)

Report
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]

Was this reply helpful? Yes No