topic Re: Date Format Issue in QlikView

Date Format Issue

Qlik__Vinodh — Mon, 02 Sep 2013 05:47:59 GMT

HI Friends,

What is the date format of this date in qlikview.

17-05-10 11:32:45.000000000 AM

if any one knows pls help me

Re: Date Format Issue

tresB — Mon, 02 Sep 2013 05:55:09 GMT

DD-MM-YY hh:mm:ss.fff TT

Re: Date Format Issue

jagan — Mon, 02 Sep 2013 06:05:34 GMT

Hi,

The format for this date is

=Timestamp(Timestamp#('17-05-10 11:32:45.000000000 AM', 'DD-MM-YY h:m:ss.fff TT'))

Regards,

Jagan.

Re: Date Format Issue

v_iyyappan — Mon, 02 Sep 2013 06:06:26 GMT

Hi,

Use like this you will get the above datetime:

=Date(Date#('17-05-10 11:32:45.000000000 AM','DD-MM-YY hh:mm:ss.fff TT'),'DD-MM-YY hh:mm:ss.fffffffff TT')

Regards,

Re: Date Format Issue

er_mohit — Mon, 02 Sep 2013 06:24:49 GMT

The Date format is DD-MM-YY

You can use subfield function for getting only date

try this

Date(Date#( SubField(F3,' ',1))) as Date //here F3 is 17-05-10 11:32:45.000000000

if you know about the format then it is

DD-MM-YY hh:mm:ss.fff TT

Re: Date Format Issue

ashwanin — Mon, 02 Sep 2013 06:34:28 GMT

and still if all above suggestions are not working, then change the date format from Control panel -->Regional office and language. to the format : DD-MMM-YYYY.

rgds

Ashwani