Converting WeekNo to Date format

[ajsjoshua]

Hi,

I want to convert my Weekno to date format.

Weekno

4

5

6

7

8

9

10

And i also want to find starting date of the week.

Regards,

Joshua.

[tamilarasu · Accepted solution]

Hi joshua,

Try MakeWeekDate() function. Syntax should be

MakeWeekDate(Year, Week)

Load Script:

Load *,

MakeWeekaDate(YearField,WeekField)

From source;

Expression:

=MakeWeekDate(2016, 24)

[ajsjoshua]

Hi Sago,

Its working bro

=MakeWeekDate(Year, Week)

how to calculate the day start of this.

Regards,

Joshua.

[tamilarasu]

By default, the MakeWeekDate function shows monday as start of the week.

[ajsjoshua]

Hi

tamilarasu

Nandri sago Its working fine.

[tamilarasu]

Welcome bro.