topic Re: Format date problem in QlikView

Format date problem

pgalvezt — Mon, 30 Jul 2012 19:36:30 GMT

Hi, I've tried to calc into my formula a date variable. but nothing happened

I tried all this options:

//Let vDate = num(makedate(DD/MM/YYYY));

//Set vDate = Date(DD/MM/YYYY);

//Set vDate =$(vDate);

//Set vDate =num(date('$(vDate)'));

//Set vDate = Date(DD/MM/YYYY);

//LET vDate = Num(MonthEnd(today()));

//LET vDate = date#(dd-mm-yyyy);

My Final result always is a number.

I need to rest (vdate-Date)

Thank You.

Re: Format date problem

pgalvezt — Mon, 30 Jul 2012 19:59:59 GMT

I tried this to but nothing:

LET vDate = date(date#(dd/mm/yyyy));

if(sum(date(Date#('$(vDate)'))-TD_Mora)= date(Date#('$(vDate)')), Dual('Al Día',1),

if(sum(date(Date#('$(vDate)'))-TD_Mora)>=1 And sum(date(Date#('$(vDate)'))-TD_Mora)<=30, Dual('1-30 Días',2))) as EST

In my Variable panel appears 10/05/2012. Thats ok But in my Dimension EST appears -

With the total Expression.

Thank you.

Re: Format date problem

pgalvezt — Mon, 30 Jul 2012 21:53:13 GMT

Any Help. ah! This formula works as Dimmension Calculated but not in the script.

Thanks

Re: Format date problem

swuehl — Mon, 30 Jul 2012 22:09:00 GMT

I believe something like

LET vDate = date(date#(dd/mm/yyyy));

is not a valid syntax. dd/mm/yyyy looks like a format code, but you should put the code in single quotes and use it as second (optional) argument. First mandatory argument (which I can't see here), should be the date string you want to interpret.

Maybe more important than the syntax: What date do you want to assign vDate to?

Re: Format date problem

pgalvezt — Mon, 30 Jul 2012 22:20:19 GMT

The variable should be stay like DD/MM/YYYY.

I put my code for better comprenhension. The idea is gets the calc in the script and not the Dimmension Calculated. QlikView its getting too slow.

Thank You.

Re: Format date problem

pgalvezt — Tue, 31 Jul 2012 13:16:32 GMT

Any Help?.

Thanks.

Re: Format date problem

pgalvezt — Tue, 31 Jul 2012 13:52:40 GMT

Anyone can help me with this please.

Thanks!

Re: Format date problem

CELAMBARASAN — Tue, 31 Jul 2012 14:15:35 GMT

Are you trying to compare with today's date?If so then it should be

LET vDate = date(Today(),'DD/MM/YYYY');