Display the Weekend Date

[Iamwilliamlo]

trying to search in past post but not found what i want.

i had the weeknum on column1 (e.g. wk1). i want to display the actual end date on column2(e.g.4-Jan-2020). 

i tried to put DayName(Weekend(WEEKNUMBER)) in expression but it comes out 1/6/1900.

weird that wk 234567 was same displayed 1/6/1900.

thks and apprec your help

[tresesco]

You need a date field here. If you don't have one, you should have other date fields like, year, month. Could you share how you created these script fields? 

[arulsettu]

Yes you need a date field to create the weekend 

WeekEnd('2020-08-11')

or create one using  year field for example

WeekEnd(MakeWeekDate(2019,33))

[Iamwilliamlo]

encl please find the screen cap.

[arulsettu]

Provide a sample app 

[Iamwilliamlo]

sorry i cant understand your meaning of provide sample app.

[Iamwilliamlo]

Script was DayName(Weekend(WEEKNUMBER))

[arulsettu]

Share your qvf file

[Iamwilliamlo]

sorry that i  cannot share any qvf file since mine was not full version.