Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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