3 Replies Latest reply: Feb 7, 2011 8:07 AM by Fayez Tayyar RSS

    How to solve date Issues

      Hi,

      I am trying to load dates field into QlikView and am trying to specify the month name by using monthname or month functions but its not working.

      Original date fields data looks like this: 15/07/1992 12:00:00 AM. I want to extract month names from this field but I couldn't, when using monthname function its returning the first day of the month 1/07/1992 12:00:00 AM, and when using month function it is returning wrong dates (in year 1900) .

      My other question is that I want to load dates upon condition i.e, I want only dates which are greater than 1/01/2011.How can i do that.

      Thank you in advance.

      Cheers,

      Fayez