Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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))
encl please find the screen cap.
Provide a sample app
sorry i cant understand your meaning of provide sample app.
Script was DayName(Weekend(WEEKNUMBER))
Share your qvf file
sorry that i cannot share any qvf file since mine was not full version.