Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
1) I’m trying to change numbers from Days column to a Day name but can’tconverted using below script but failed.
DayName(MakeWeekDate($(TranxYear),num(Mid(Weeks,6),'00'),iterno()-1 )) as DaysName,
2) In this script it will shown day from Monday to Sunday. What if the script for only exclude Saturday and which is the data will shown from Mon,Tue,Wed,Thurs,Fri and Sun?
Please advise me.
Hi hairulannuar,
Did you try this function yet : WEEKDAY(DateField)
Regards,
Sokkorn Cheav
Hi hairulannuar,
Did you try this function yet : WEEKDAY(DateField)
Regards,
Sokkorn Cheav
Try
WeekDay() function that will definately help you.
Regards,
Nitin Jain