3 Replies Latest reply: Aug 30, 2012 7:46 AM by cristian_cazan RSS

    Date Visualisation/Selection

      Hi guys,

      I'm having a important date field shown as : DD/MM/YYYY HH:MM:SS.

       

      In my visual QlikView file i want to make a lot's of possible date selection : i want to select MONTH and then YEAR, or MONTH - YEAR ...

      I try to use sintax Dual(Month(MyDate) & '-' & Date(MyDate, 'YY'), Num(Year(MyDate)) & Num(Month(MyDate), '00')) AS MonthYear but it's not working on my script ..

       

      Any ideeas?

      Thanks.