topic Date format text box in QlikView

Date format text box

Mon, 16 Apr 2012 12:24:27 GMT

Hi Guys,

I have a text box formula and I wish for it to give me yesterdays dates , if yesterday was a weekday , if its not then give me fridays date.

The following is correct where it comes to the Date part of it but it is resulting in 13/00/2012

I have fluted around with it and always the Month is 000,

Can anyone advise please ?

=date(if(weekday(today()-1) * 1 <5,today()-1,today()-3),'dd/mm/yyyy')

Date format text box

Mon, 16 Apr 2012 12:27:35 GMT

date(if(weekday(today()-1) * 1 <5,today()-1,today()-3),dd/mm/yyyy)

Silly me took off the quotation marks and we're hunky dory

Sorry

Date format text box

hic — Mon, 16 Apr 2012 19:05:14 GMT

No, the single quotes should be there. But the format code is (sometimes) case sensitive: 'mm' means minutes and 'MM' means month. So the date function should be date( ... ,'DD/MM/YYYY')

/HIC

Date format text box

Tue, 17 Apr 2012 07:51:13 GMT

Thanks Henric

Date format text box

Tue, 17 Apr 2012 07:59:09 GMT

Wait Henric,

How come removing the quotation marks worked then , is there a detriment to just taking then off

Im not familiar with alot of the nuances of Qlikview any info would be great

Thanks again
Anne

Date format text box

hic — Tue, 17 Apr 2012 08:11:33 GMT

If you don't have the quotes, then QlikView will interpret dd/mm/yy as the field "dd" divided by the the field "mm" divided by the field "yy". But since there are no such fields, this expression will evaluate as NULL.

This means that you have a date function with NULL as second parameter - then QlikVIew will use the default date format defined in the SET statement in the beginning of the script. And then the date function works...

You could simplify everything by omitting the second parameter of the date function.

/HIC

Date format text box

Tue, 17 Apr 2012 08:14:48 GMT

Thanks Henric

I understand a little better now