huddds
huddds

Reputation: 1045

show only weekday from date

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.

Upvotes: 0

Views: 164

Answers (1)

Kiran Hegde
Kiran Hegde

Reputation: 3681

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.

Upvotes: 1

Related Questions