topic Re: Get Week in App Development

Get Week

Loeckli — Fri, 08 Jul 2022 14:05:38 GMT

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 — Sat, 09 Jul 2022 10:06:03 GMT

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 — Sat, 09 Jul 2022 13:52:47 GMT

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

thanks