problem in calculating query design

[former_member309586]

Hi Gurus,

I have some requirement from user which i am not able to do it .

1,How do i calculate number of working days in a month ? How can i create a variable ? Please give me some hints.

2.How do i calculate "Number of working days past in this month" ? Please gurus help me .

I will be very thankful to you.

Thanks a Lot

Regards,

Raj

[Former Member · Accepted solution]

Hey

Raj,

The code in the link will help you if you are going to use it in ur update rules....and after tht u can use tht characteristics into ur query as a variable

Reply me if u require further help on code!!

Regards

Ankur Shah

[former_member309586 · Accepted solution]

Hi Ankur,

Actually i want no.of working days to be calculated in a query design .Can you please help me in getting code?

I will be very thankful to you

Thanks a Lot

Regards,

Raj

[former_member309586 · Accepted solution]

CLOSED

[Former Member]

check this thread and see if it might help..

assign points if it helps