I have some data which contains rows and rows of data which is updated on a weekly basis.
I was hoping to filter out only the rows where the date is today's date. The issue I have is that when I print the data out in an HTML table, the date gets converted into the numeric equivalent (so, 45867 instead of 29th July).
In your List Rows action, ensure your DateTime Format parameter is set to ISO 8601. Excel stores dates in Unix format and converts from that, so you need to choose the correct format when getting the rows.
If this comment resolves your issue, please remember to mark it as the answer.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
62
Share
Report
All responses (
Answers (
