Date Format Issue

[Qlik__Vinodh]

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

[tresesco]

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

[jagan]

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.

[v_iyyappan]

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,

[er_mohit]

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

[ashwanin]

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