Hi,
I'm trying to update the row of the current day in a excel file, but microsoft flow take the dates in the table as number and I don't know how convert the dd/MM/yyyy to a number, how can I do that?
Thanks.
Solved! Go to Solution.
Hi @brayanrm0097 ,
You could use the following expression to covert utcNow() to the number like the value stored in the Date column.
div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks('1899-12-30')),864000000000)
Then configure this number in Date column as key-value to update the corresponding row.
Please take a try and see if it helps.
Best Regards,
Proud to be a Flownaut!
Hi, thanks for answer,
I have an excel table with a date column that I want to use for the "Key column" in the excel block, for find the correct row depending of the current day and update the next column.
I tried this simple line for get the current date, but can't use it for the "Key value" because Microsoft flow get date in excel as a number.
Proud to be a Flownaut!
Hi @brayanrm0097 ,
You could use the following expression to covert utcNow() to the number like the value stored in the Date column.
div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks('1899-12-30')),864000000000)
Then configure this number in Date column as key-value to update the corresponding row.
Please take a try and see if it helps.
Best Regards,
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
86 | |
58 | |
50 | |
42 | |
37 |
User | Count |
---|---|
91 | |
76 | |
74 | |
61 | |
42 |