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: 
paulwalker
Creator III
Creator III

Week's

Hi Community,

PFA,

i want to calculate week's.

suppose JAN month weeks, same as FEB and so on.....


7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Use Week(TempDate) ...

Let me know

ashfaq_haseeb
Champion III
Champion III

Hi,

Try week(Your_Date) as Week.

Regards

ASHFAQ

mdmukramali
Specialist III
Specialist III

Dear,

Week(TempDate) as weekNumber

paulwalker
Creator III
Creator III
Author

Hi All,

that is ok, but i need w1, w2, w3, w4 and w5 like this...

each and every month.....

suppose JAN month W1,W2,W3 and W4

MARCH month W1,W2,W3, W4 and W5

VishalWaghole
Specialist II
Specialist II

Hi Paul,

use week(OrderDate) as weekNumber.

Hope this will help you.

-- Regards,

Vishal Waghole

paulwalker
Creator III
Creator III
Author

Hi All,

actually my data was wrong, that's why it showing wrong data..

sorry for your valuable time.....

ashfaq_haseeb
Champion III
Champion III

Hi,

Can you close this thread.

Regards

ASHFAQ