Convert Date Expression to DateFormula

spiky_golden

I have some difficulty to convert expression like "-CW" into a date formulavariable. We are using both French and English environment so using "-CW" is cause quite a issue.

What I need to do is to calculate the first day of the current week. Then Find the first day and the last day of next week and the same thing for the week after.
1- I'm using "-CW " to get the first day of the current week.
2- I'm using "+1W" to get the first day of the next week from the date find in step 1
3- Then "+1W-1D" from the date find in step 2 and so on...

It is working great as long as the users don’t use the French version... I Read that using DateFormula variable will become language insensitive but I can't figure it out...

Any idea on how i can convert the code?

kriki

To make the dateformulas international, use < and >. Example : '<1M>' or '<CW>'.

spiky_golden

kriki, it works like a charm!

Thanks

vaprog

spiky_golden wrote:

I have some difficulty to convert expression like "-CW" into a date formulavariable. We are using both French and English environment so using "-CW" is cause quite a issue.

...

It is working great as long as the users don’t use the French version... I Read that using DateFormula variable will become language insensitive but I can't figure it out...

To assign to a DateFormula variable you need to use EVALUATE unless you have a value of type DateFormula already that is stored in some variable or field. C/AL does not provide any way to specify a DateFormula constant. So, all you can do is provide the formula as a string, which is language sensitive unless surrounded by < and > as kriki said.

Btw, CALCDATE takes a text, code or dateformula as its DateExpression parameter.

spiky_golden

In fact with the '<>' trick I don't even need dateformula. Everything works like a charm I just wish I had read the doc carefully as I just read it this morning... But hey, no one is perfect!

kriki

Let's throw in some Chinese ... euh ... informatics saying: When all else fails, try to read the <beeeeep> manual.