week day number

[dhavalvyas]

Hi,

I have raw data contains data for two month.

1>while I am selecting date from first 7 days it will shoe week no as 1

2>similarly while I am selecting date 21 it will show week no as 3

so what is logic for that can any one suggest any solution ???

[prat1507]

maybe this

Num( Week(Date) ) - Week( MonthStart(Date) ) + 1

Regards

Pratyush

[MK9885]

In backend for your script the below would give you week...

week(YOURDATEFIELD) as Week

[MarcoWedel]

What are the week numbers of your second month?