[DateFormula] Handle DateFormula translation in code ?

(0) Share

Report

Posted on by jdecottignies

217

Hi,

I think I'm struggling with an issue that exist for a long time but I try anyway.

The context is a setup table containing some DateFormula fields.

This field is used with a CalcDate() at some point in my code.

When the language is in english, the CalcDate is performed succesfully.

If the language is in French, I have this error:

"Date Formula -2S must contain a Time Unit. Time unit can be J, JS, S, M, T or A, C..."

Please note that the 'S' I provided is listed in the error as a valid time unit.

In my code, if I hardcode CalcDate('<-2W>', refDate); there is no problem.

It seems the system is not translating the date formula value in english when we are in another language. But tell me if i'm wrong.

My question:

Is there an easy "universal" way to use date formula in the code? Or do I have to translate the formula by myself according to the system language ?

Thanks for any help

I have the same question (0)

All responses (1)

Answers (0)