Another date question

[#1]

Hi All,

This is my first question.

Our software package stores data in SQL dates as 1090720

Now if I bring in the date like this it works fine and gives me 2009/07/20

makedate( '20'&mid("EV200_MI_DATE",2,2), mid("EV200_MI_DATE",4,2), mid("EV200_MI_DATE",6,2) ) as EV200_MI_DATE,
[\code]

My problem is I cannot use this date in an input box to select a from and a to date.

Any help?

Thanks

Pieter
 </body>

[#2]

fast solution, you can use mapping table between two types of dates in sql and fetch both of then to sql and use DD and MM and YYYY for input box

[#3]

Thanks for the quick reply. I'm off to learn mapping quickly. Did I mention I just started to learn Qlikview?

Regards

Pieter

[johnw]

You can build the date more simply like this:

date#(right(EV200_MI_DATE,6),'YYMMDD') as EV200_MI_DATE

I don't generally like having the users enter a from and to date. Typically, they want something more basic, such as being able to select a year, or a quarter, or a few months, that kind of thing. So I give them those fields and let them select what they want.

If the date ranges don't tend to follow nice boundaries like that, you can also select a date range using a multi-value slider. I have a few of those sprinkled through my applications. Finally, yes, you can use an input box with variables for the from and to date, but you'll need to use a macro to actually select that date range (actions in version 9?), which I don't tend to think of as "the QlikView way". I don't think I have any applications that use that approach.