Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert weekday to a date

Hi,

I have a list of articles and weekdays they arrive.

Example:

ArticleArrivalDay 1ArrivalDay 2
Article1MondayFriday
Article2WedensdayFriday
Article3MondayTuesday
Article4TuesdayThursday

Today is 20-03-2013, and I wonder if there is any way to convert the weekdays to Dates... The date should be the first upcoming date (or todays date) that matches the weekday.. euhm.. my bad english makes it hard to explain

Anyway, result that I want is this:

ArticleArrivalDate 1Arrival Date 2
Article125-03-201322-03-2013
Article220-03-201322-03-2013
Article325-03-201326-03-2013
Article426-03-201328-03-2013

Any help is appreciated

thanks in advance.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached example


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks you so much, that´s awesome!

I haven´t really figured out how it works yet but hopefully I will