Hello. I’m new here. I’m trying to calculate the difference between today’s date and upd date (format “XXXX-XX-X XX:XX:XX”), in days. I’m trying this but no luck. {{(now - formatDate(get(5.data.prestashop.order.date_upd; 0); yyyy-MM-dd HH:mm:ss; X)) / 86400}} Any idea ? Thanks Arthur

This works {{(formatDate(now; “X”) - formatDate(5.data.prestashop.order.date_upd; “X”)) / 86400}} Thanks a million

Date difference

momomomonmon February 11, 2025, 4:36pm 6

@a_gio
I am happy to have been able to help!
I am sorry to trouble you, but please just specify the Solution.

1 Like

Topic		Replies	Views
Comparing two dates How To functions	9	3158	August 3, 2024
Date Manipulation How To date-time-functions	2	1546	December 7, 2023
How to calculate days between dates, returns empty How To date-time-functions	3	257	July 28, 2024
Date time parameters to check google sheets vs current time How To filters , mapping , google-sheets	4	772	March 12, 2024
Problems when filtering data with the datetime operator later than/ earlier than How To filters , date-time-functions	6	1019	March 28, 2024