Any possibility to translate Date Relative ? It is by default translated to English like “5 days ago” in French should give “Il y a 5 jours.”

The math will update automatically if you subtract NOW from the End Date. Am I understanding correctly that you are currently calculating the difference from the beginning of the promo to the end of the promo? If so, those are static dates, so yes, it won’t update. But, if you change your math to…

I think an option here is to use the fetch API column to pass that to a translation service and return the corresponding translation.

Thank you. I may have asked the wrong question. My user-case is: l want to add a discount info under each product “finishes in x hours”. I created 6 columns. Date begin | date end | math column (for substracting)*24 | ite for singular/plural hours (last condition "hours <0 then minutes | another mat…

Can you include screenshots to show how the countdown doesn’t work?

OK, one moment also date relative still in English does not update/refresh.

[Capture d’écran (191)] [Capture d’écran (192)] [Capture d’écran (193)] [Capture d’écran (190)]

You all do it right for the math and ITE columns, may I ask why do you need the relative column here if you have constructed all the other ones? I think you can just add another ITE column to have a template for your own language’s “date relative” version.

Because it does not refresh. The same durations are displayed.

Thanks. Yes this is what I am going to do. The relative date column is there because i was just trying to see if it update or not.

Thank you. @Jeff_Hager My mistake was and I advise anyone who use Math Column: Never put the sign “-” in a column title because if you use it in a formula, it is interpreted as a subtraction !!! :crazy_face:

Ah, I thought that was part of your math. It’s true that any math symbols in a math formula will be interpreted as math. However, it has nothing to do with your column headings having a ‘-’. The problem was that your replacement values had a ‘-’. Your replacement values can be anything, such as …

Date relative translation

Ask for Help

Jeff_Hager December 7, 2021, 4:13pm 18

Take a look at this and let me know if you have questions.

Topic		Replies	Views
Relative Time + Experimental Code to Translate it? Ask for Help	52	1920	November 23, 2021
Localize "Relative Time" column Ask for Help	4	347	July 23, 2022
🆕 Format Date Plugin General	58	2557	August 22, 2022
🆕 Date-time Math General data-editor	126	14076	September 27, 2023
'3 days ago', 'a month ago' 'tomorrow' Ask for Help	17	2616	September 27, 2023

Date relative translation

Related topics