How to solve date Issues

[#1]

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

[spsrk_84]

Hi,

Try in this way

MONTH(DATE('15/07/1992 ','DD/MM/YYYY')

first thing use like this in your script suppose if your date field name is TargetDate then use

MONTH(DATE(TARGETDATE,'DD/MM/YYYY'))

this will give u the months

and in the same way apply filter condition i.e DATE(TARGETDATE,'DD/MM/YYYY') > '01/01/2011'

if this is not working then send sample data.

Regards,

Ajay

[#3]

Thank you so much.

the first one is working fine..

Now regarding the date >'01/01/2010' it is returning 0 & -1, what i actually need is to return all the date above this day.

Thank you agian.

Cheers,

Fayez

[#4]

Thank you so much.

the first one is working fine..

Now regarding the date >'01/01/2010' it is returning 0 & -1, what i actually need is to return all the date above this day.

Thank you again.

Cheers,

Fayez