Help with changing a date and then using for calculation

Anonymous — Mon, 15 Jul 2013 10:54:11 GMT

Hi, I'm still on a large learning curve with Qlikview and I'm stuck. I have a date field which appears in an extract imusing in the format DD.MM.YYYY, I have worked out how to change but now I'm unable to use the new date format i created in a calculation.

Date

(Date#([Requested deliv.date],'DD.MM.YYYY'),'DD/MM/YYYY') as [Requested deliv.date2],

I then want to say

([Requested deliv.date2]<=Today(),year(Yearname(today(),1,8))&'Q'&ceil(month(MonthName(today(), 5)) / 3),year(Yearname([Requested deliv.date2],1,8))&'Q'&ceil(month(MonthName([Requested deliv.date2], 5)) / 3))as Req_Delivery_Qtr,

When i run my script the Req_Delivery_Qtr is blank. I know that if i create the data ( in my extract) as DD/MM/YYYY the formula works.

I also know that the Requested deliv.Date2 is coming correctly.

Is this because of the way i am loading the data. Do I need to wait untill this table is fully loaded before making the calculation ? If so how do i do that ?

Thanks

Re: Help with changing a date and then using for calculation

rajni_batra — Mon, 15 Jul 2013 11:37:28 GMT

Hey, Can u post sample app, as i tried with ur exp its working fine here.

See the attach application

topic Help with changing a date and then using for calculation in QlikView

Help with changing a date and then using for calculation

Re: Help with changing a date and then using for calculation