Find the Week Name of the Date

[Ramu]

Hi All,

I have Date Dimension ,I want to get the week name of each date ,weekday (), I used Weekday( ),Day Name( ) functions .But I didn't get the Solution.  And I want to Get only Week day Sales information Only .

Date

25-May-2019

26-May-2019

27-May-2019

28-May-2019

29-May-2019

30-May-2019

31-May-2019

Out Put
Date	New Date
25-May-2019	Saturday
26-May-2019	Sunday
27-May-2019	Monday
28-May-2019	Tuesday
29-May-2019	Wednesday
30-May-2019	Thursday
31-May-2019	Friday

Anyone Please let me know the solution.

Thanks.

[PrashantSangle · Accepted solution]

USe WeekDay() function

[PrashantSangle]

If you want full name of it.
then in script update variable DayNames like below

SET DayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

[Ramu]

Hi PrashantSangle,

Thanks.