Date

[qlikview979]

Hi Experts I have data like this

01-01-2016	02-02-2016	03-03-2016
1	4	7
2	5	8
3	6	9

When i load the data  i am getting fields like

[42370],

[42402],

[42432]

if am using date function its coming correct data , but data is not coming .

Regards

Mahesh

[arulsettu]

sunny also already mentioned only way is renaming

[arulsettu]

have u tried it will change whole data format.

[miguelbraga]

See my attached file:

Regards,

MB

[trdandamudi]

Ok. Here is the solution without renaming. What you have to do is in Excel make sure for every column header you have a space in the front and save it. Then use my attached file you will get what you need.

Example:

If your column header is 1/1/2016 then put a space in front and then enter 1/1/2016.

I am attaching both excel file and qlikview file. Hope this helps..

[Colin-Albert]

You can change this on the Document Properties.

Settings / Document Properties / Number

Select the date field and change the number format setting for the field to Date with your preferred formatting.