First Value

[#1]

Hi,

I have a week that is mapped to two periods.

For eg: 2014 W18 is mapped to both 2014 April and 2014 May.(5 days in April and 2 days in May)

But I would like to have2014 April to be mapped for 2014 W18.

Could anyone help me to get the logic.

Thanks &regards,

Vinitha

[Anonymous]

place me the sample application

Then we can understand easily..

[CELAMBARASAN]

How you are creating the week?

Post your script on creating this calendar and the sample app. we need to be little bit clear in understanding this

[Anonymous]

Hi,

I believe, you already have calendar table with weekno and dates and you are mapping weekno to your transaction table. Try using WeekStart function.

=MonthName(WeekStart(Date))

Thanks

[hic]

If your week is defined by Week(Date), then Month(Date) will always return 'May' for the last days of that week.

However, if you instead define Month as

     Month(WeekStart(Date)) as Month

then it will work the way you want.

HIC