Logic help Year and week to

[abhaysingh]

I have Month and Week in one  table ,

how i can create dates from it?

i want week and month start date from year and week available in my data.

year are like 2015,2016 etc.

week are like 01,02,03, till 53

kindly suggest

[jagan]

Hi,

Try MakeWeekDate() to create date field.

Regards,

Jagan.

[Anonymous]

sample data?

Can we customize month or create month on the based of week?

something like first 4 0r 5 week as Jan, then next 4 as Feb and so on...

[abhaysingh]

this gives me week start date, but i can get monthstart date from here?

[Anonymous]

did you try like this?

monthstart(weekstartdate(week))

monthstart(makeweekdate(week))

[jagan · Accepted solution]

HI,

Then use like below

MonthStart(MakeWeekDate(Year, Week))

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Ohh...syntax error...try as jagan mohan rao appala

suggested.