topic Re: Date format ?? in QlikView

Date format ??

sushil353 — Mon, 10 Oct 2011 12:02:12 GMT

Hi All,

I have a field Day_date in 10/8/2011 format (MM/DD/YYYY)

i want to show it using a text object in Sep 8, 2011 format...

Please suggest how can i achieve this....

Thanks

Sushil Kumar

Date format ??

Michiel_QV_Fan — Mon, 10 Oct 2011 12:04:39 GMT

date(yourfield, 'MMM DD, YYYY')

Re: Date format ??

its_anandrjs — Mon, 10 Oct 2011 12:05:18 GMT

Hi,

You have to change date format like

10/8/2011 format (MMM D/YYYY)

use this code to change format =Date(DateField,'MMM D,YYYY')

See the attached sample file.

HTH

Rgfds

Anand

Date format ??

Mon, 10 Oct 2011 12:09:56 GMT

Hi,

You can try:

Date(Day_date,'MMM DD, YYYY')

Regards,

Re: Date format ??

Mon, 10 Oct 2011 12:11:42 GMT

The least standard but most flexible solution 🙂

=month(Day_date) &' ' & day(Day_date) & ',' & year(Day_date)

Regards,

Robert

Re: Date format ??

its_anandrjs — Mon, 10 Oct 2011 12:16:41 GMT

Hi,

You can use some thing like this if you want for only perticular date like today

=Date(today(),'MMM DD,YYYY')

Rgds

Anand

Date format ??

Michiel_QV_Fan — Mon, 10 Oct 2011 12:19:35 GMT

Yes, if you add a text object with this statement you have your answer

Date format ??

its_anandrjs — Mon, 10 Oct 2011 12:24:02 GMT

Hi,

If you want to display perticular date from date filed like Day_date so put some condition like

If( Day_date = 10/8/2011, Date(Day_date, 'MMM D,YYYY' )

Rgds

Anand