Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ???
maybe this
Num( Week(Date) ) - Week( MonthStart(Date) ) + 1
Regards
Pratyush
In backend for your script the below would give you week...
week(YOURDATEFIELD) as Week
What are the week numbers of your second month?