show only weekday from date

Question

I'm trying to use a date value I have in my table to show the start date of a holiday as the day value (Monday, Tuesday etc) how would be the best way to go about getting the start day value in this format in VB.NET?

I'm currently working with the date format dd/mm/yy.

Answer 1

Use Weekday and WeekdayName functions

WeekdayName(Weekday(startDate))

Weekday , which returns a number that indicates the day of the week of a particular date. It considers the ordinal value of the first day of the week to be one.

WeekdayName , which returns the name of the week in the current culture that corresponds to a particular weekday number.