topic Re: Formatting dates in text boxes in QlikView

Formatting dates in text boxes

Tue, 16 Jul 2013 08:58:56 GMT

Hi All,

I have a text box which displays the date from a listbox called 'Reporting_Date_Comp' when a date value is selected.

However, the values are not formatted.

For example, when I select '20130504' from the listbox, it will be displayed as 'Date: 20130504' in my text box.

Is there a way for me to format it such that it will be displayed as 'Date: 04/05/2013' instead?

Below is my working code in the text box:

='Date: ' & Reporting_Date_Comp

Gysbert_Wassenaar — Tue, 16 Jul 2013 09:03:13 GMT

='Date: ' & date(Reporting_Date_Comp,'DD/MM/YYYY')

It's possible that Reporting_Date_Comp is not yet a date, just a number. In that case you need:

='Date: ' & date(date#(Reporting_Date_Comp,'YYYYMMDD'),'DD/MM/YYYY')

Actually it would be better to do this conversion in the script.

Tue, 16 Jul 2013 09:06:08 GMT

Hi Gysbert,

I did the same formatting before, but it gave me this instead

Date: 22/06/57015

Is it because of its numerical representation?

er_mohit — Tue, 16 Jul 2013 09:10:22 GMT

try this

='Date: ' & date(date#('20130504','YYYYMMDD'),'DD/MM/YYYY')

Replace this with your datefield

Tue, 16 Jul 2013 09:23:53 GMT

I rewrote the script and it works! Thank you