Get Week

[Loeckli]

Hello Everybody

For some reason when I'm using the function Week(), it gives me a strange output.

I have Variable with dd.mm.yyyy which is a $numeric $timestamp. 

When I display the columns Variable and Week(Variable) next to each other. 

The function assigns the dates 24.06.2022  to 06.07.2022 to the calender week 26. 

What I'm missing ? 
Thank you for any tipp in advance 

[rubenmarin]

Hi, maybe it's something with date formats,if I use DAte#() so tell the date format it returns:

=Week(Date#('24.06.2022','DD.MM.YYYY')) -> 25

=Week(Date#('06.07.2022','DD.MM.YYYY')) -> 27

[MarcoWedel]

can you please post a small application that shows this behaviour?

thanks