topic Re: DATE Field Issue. in QlikView

DATE Field Issue.

Tue, 18 Nov 2014 12:23:22 GMT

Hi,

Here is my Source DATE Fields.

I'm getting incorrect format after loading this Excel Sheet.

I'm Getting 1/01/1900 or 1/01/1899 DATE is getting. The Month, Day and Year everything is wrong on my dashboard.

Re: DATE Field Issue.

ashfaq_haseeb — Tue, 18 Nov 2014 12:25:16 GMT

Hi,

Can you attach Excel.

Regards

ASHFAQ

Re: DATE Field Issue.

Tue, 18 Nov 2014 12:31:20 GMT

attach excel or tell us what the num value in a datecell are. You should load the data as date(yourdatefield) as datefield or idé the date# function

Re: DATE Field Issue.

rustyfishbones — Tue, 18 Nov 2014 12:35:28 GMT

Please share the excel file, so we can take a look.

Regards

Alan

Re: DATE Field Issue.

PrashantSangle — Tue, 18 Nov 2014 12:40:16 GMT

Hi,

Try like

Date(Date#(dateField,'MM/DD/YYYY'),'MM/DD/YYYY') AS New_dateField

REgards

Re: DATE Field Issue.

Tue, 18 Nov 2014 12:44:30 GMT

This happens when qlikview don't able to recognize the data type of field .

You can check each cell has same format of date or put where clause while pulling data with minimum year.

Re: DATE Field Issue.

Tue, 18 Nov 2014 12:57:09 GMT

Hi Murali,

Santosh is right, it happens when Date field is not recognized by Qlikview, By using date# function and by passing your date format(that i think is MM/DD/YYYY), you told Qlikview to change the string into Qlikview date,because Qlikview provide many function on date, after that this value can also be converted in dual format.

Regards

Harshita gaur