Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get day number from week

Hi I’m struggling getting the number of the day from a week. In a Expression

Example 16/01/2013 is Wednesday that is a 3; a Monday would be a 1 and so on.

Thanks in advance

16 Replies
martin59
Specialist II
Specialist II

What do you mean by "Dia" ?

Is your expression works ?

Martin Favier

martin59
Specialist II
Specialist II

What do you mean by "Dia" ?

Is your expression works ?

Martin Favier

Not applicable
Author

“Dia” means Day in Spanish and is a DB field, yes the expression works.

martin59
Specialist II
Specialist II

Ok sorry !

If the expression works, have you got another thing to resolve ?

Martin Favier

martin59
Specialist II
Specialist II

Ok sorry !

If the expression works, have you got another thing to resolve ?

Martin Favier

martin59
Specialist II
Specialist II

Ok sorry !

If the expression works, have you got another thing to resolve ?

Martin Favier

helder_tack
Contributor
Contributor

Could you test:

Num(WeekDay(Today()))

0 - Monday

1 - Tuesday

...

6 - Sunday