Change Date to Day name

[#1]

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.

[Sokkorn · Accepted solution]

Hi hairulannuar,

Did you try this function yet : WEEKDAY(DateField)

Regards,

Sokkorn Cheav

[#3]

Try

WeekDay() function that will definately help you.

Regards,

Nitin Jain