topic Re: date Format in QlikView

date Format

Wed, 02 Oct 2013 11:09:18 GMT

Hi,

I have a field(RDATE) in the following format

Apr 1 2013 1:00AM

Apr 1 2013 12:00AM

Apr 2 2013 1:00AM

Apr 2 2013 12:00AM

Apr 3 2013 1:00AM

Apr 3 2013 12:00AM

Apr 4 2013 1:00AM

Apr 4 2013 12:00AM

Apr 5 2013 1:00AM

Apr 5 2013 3:34PM

Apr 5 2013 4:34PM

Apr 5 2013 12:00AM

Apr 6 2013 1:00AM

Apr 6 2013 12:00AM

Apr 8 2013 1:00AM

Apr 8 2013 12:00AM

And I' am required to convert the above date format into DD/MM/YYYY. After converting the above I need to make use of the above field in a calendar object, I' am stuck somwhere and not getting the required results.

Kindly help

Re: date Format

Clever_Anjos — Wed, 02 Oct 2013 11:26:53 GMT

date(floor(RDATE),'DD/MM/YYY')

Re: date Format

Anonymous — Wed, 02 Oct 2013 11:42:38 GMT

Hi Gaurav.

Try Using:

Date( Date#('Apr 1 2013 1:00AM', 'MMM D YYYY hh:mmTT') )

For testing....

And than replace the String for your date column

Re: date Format

Wed, 02 Oct 2013 11:49:43 GMT

Hi Anjos,

The Solution suggested by you is not working and it's showing blank field. Any other way of achieving it

Re: date Format

v_iyyappan — Wed, 02 Oct 2013 11:50:26 GMT

Hi,

Try like this

Date(TimeStamp#(RDATE, 'MMM D YYYY hh:mm TT'),'DD/MM/YYYY' )

Regards,

Re: date Format

Anonymous — Wed, 02 Oct 2013 11:55:12 GMT

Gaurav, here is na attached example, using

Date( Date#(RDATE, 'MMM D YYYY hh:mmTT') )

Re: date Format

Clever_Anjos — Wed, 02 Oct 2013 11:56:21 GMT

Your RDATE is a date or string field?

date(floor(date#(RDATE, 'MMM D YYYY hh:mmTT')),'DD/MM/YYYY')

Re: date Format

felipe_dutra — Wed, 02 Oct 2013 14:35:17 GMT

Hi!

Try this:

MapMonth:

Mapping

LOAD * Inline

[

x, y

Jan, 1

Feb, 2

Mar, 3

Apr, 4

May, 5

Jun, 6

Jul, 7

Aug, 8

Sep, 9

Oct, 10

Nov, 11

Dec, 12

];

Tab:

LOAD

Date(SubField(Replace(RDATE, ' ', ' '), ' ', 2)&'/'&

ApplyMap('MapMonth', SubField(Replace(RDATE, ' ', ' '), ' ', 1), Null())&'/'&

SubField(Replace(RDATE, ' ', ' '), ' ', 3), 'DD/MM/YYYY') as RDATE

FROM

...

Re: date Format

Wed, 02 Oct 2013 16:08:01 GMT

Many thanks Lucas for your help

Re: date Format

Clever_Anjos — Wed, 02 Oct 2013 20:10:38 GMT

If you want only dates, remenber to use "floor"