Extract name of date from given date

Hi everyone,

I am having struggle extracting the name of the day from given date. For example, I input “4/18/22”.

If I do CDate (Input_Date.Tostring).Tostring (“MMMM”).Tostring it outputs April.

However, if I do CDate (Input_Date.ToString).Tostring (“DDDD”).Tostring it doesn’t output “Monday” or any other name of day.

@RPA_Path

Try below expression to get day from Date.

       CDate("4/18/22").Day

It outputs “18”. However, the desired output is “Monday”

@RPA_Path

Sorry it’s my bad. Please try below expression.

      CDate("4/18/22").DayOfWeek
1 Like

It worked. Thank you.

1 Like

That’s because the code for the name of the day isn’t DDDD it’s dddd. These are case sensitive.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.