Calcdate for Multilanguage in Cloud BC

julkifli33

Hi All,
I have customer in cloud bc.
some of users are using English, some are using Danish.
I have created some of the date using calcdate
e. g :
StartDate := Calcdate('-CY',Today);

if user select English language then no problem.
but if user select Danish, then it will show error message :
"Fejl: Der skal indgå en tidsenhed i datoformlen '-CY'.

Tidsenheder kan være: D,UD,U,M,K eller Å.
L, der betyder aktuelle tidsenhed baseret på dato, kan specificeres som et præfiks for tidsenheden.."

any idea how to resolve this?

ShaiHulud

if you wrap your date expression is less-more signs, it will ignore locale settings and calculate the same for everyone. So, your code should be:

StartDate := Calcdate('<-CY>',Today);

See official documentation on it here

ShaiHulud

if you wrap your date expression is less-more signs, it will ignore locale settings and calculate the same for everyone. So, your code should be:

StartDate := Calcdate('<-CY>',Today);

See official documentation on it here

julkifli33

Hi @ShaiHulud thank you so much