Week function not working when year changes.

[Anonymous]

I use the Week function to get the week difference between dates but as the year changed I started facing problems. Can anyone help me with this?

[isingh30]

Can you share your data or app?

[MarcoWedel]

Hi,

maybe you could use some expressions like

I:

Div(Date2-Date1,7)

or

II:

(WeekStart(Date2)-WeekStart(Date1))/7

hope this helps

regards

Marco