Converting date format

[#1]

Hi,

I have the following date format in my system = 01.01.2013

When I import this into Qlikview it comes across as a string like this = 79869598

Any ideas on how to change this a date in Qlikview?

I've used functions date and #date...

Many Thanks

[#2]

HI ,

     I dont find any Algorithm flow to convert the Number to DateFormat .

//Yusuf

[#3 · Accepted solution]

I found a solution to this issue in the below link

Thanks for the help

http://community.qlik.com/thread/15779

[Anonymous]

Hi ,

The same I have tried to extract year but I didn't get the accurate result...

I tried the below script but it not working ...

ABC:

LOAD Date#(Date, 'DD/MM/YYYY') as Date,

     Year(Date#(Date, 'DD/MM/YYYY')) as year,

     Name,

     Product,

     Sales

FROM

CORE_DUP\123.txt

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Data:

Date	Name	Product	Sales
3/17/2013	Jim	Ac	8586
1/9/2010	Jack	Tv	8641
11/27/2014	Jill	Laptop	9295
6/18/2014	Jane	Ac	5537
12/25/2009	Jullian	Tv	5365
11/14/2010	Jissu	Laptop	8183
2/20/2012	Jiki	Tv	8627
5/14/2014	Jean	Laptop	8500
5/23/2012	Jolly	Ac	7320

[Koniki]

you said only one format 

but you different formats in  excel in that case 

you should be use   date#(alt(datefield,'actula format','required format');