Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Loeckli
Contributor III
Contributor III

Get Week

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 

Labels (1)
2 Replies
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