Get Number From Day Name

[bewsh1987]

Hi All

Is there an expression that will return the day name to day number Monday = 1, Tuesday = 2..... Sunday = 7

I can easily do it from day number to day name however I would like to do the reverse

I can create my own function to do this no problem(Trying to stay away from VBA)

I would like to do this as an expression only



Thanks in advance

[ranman256]

They already have constant values....

vbMonday
vbTuesday
etc

if format("w",date()) = vbMonday then

[bewsh1987]

They already have constant values....

vbMonday
vbTuesday
etc

if format("w",date()) = vbMonday then

Thanks for replying however this is not what I am looking for

I have a table with day names Monday Tuesday etc, in the query I would like the [Day_name] to show a number using expression (no vba)

Monday = 1, Tuesday = 2..... Sunday = 7

again with no vba

Thank you

[June7]

Switch([Day_name]="Monday",1, [Day_name]="Tuesday",2, [Day_name]="Wednesday",3, ...you finish)

[bewsh1987]

Switch([Day_name]="Monday",1, [Day_name]="Tuesday",2, [Day_name]="Wednesday",3, ...you finish)

Works a treat

June7 Thank you thank you and thank you

[ranman256]

Put it in a table.
monday, 1

etc