Date Format

[Anil_Babu_Samineni]

Hello,

I have date field in excel. Now, i want to convert to qlikview date format. Suggest me, Because when i am trying to create one list box with the year it showing 1899 & 2014. But i have only 2014 Data in my excel. Please help me?

My excel date has 3/26/2014  12:00:00 PM

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

2014:

LOAD rep as [2014 rep],

     franchise as [2014 franchise],

     product as [2014 product],

     Date as [2014 Date],

     Year(Date) as [2014 Year],

     Score as [2014 Score],

     groupObservation as [2014 groupObservation],

     name as [2014 name],

     Username as [2014 Username]

FROM

[2014Data.xls]

[MindaugasBacius]

All the functions that ends #: time#, date#, money# etc. are interpretation functions. It means that the user defines how to interpret the data.

[Anil_Babu_Samineni]

Nice Chanty

Simple explanation and perfect understanding. Thanks guys.

[sunny_talwar]

Anil -

I think that you have not familiarized yourself with the QlikView/Qlik Sense Help yet. What Chanty provided are direct extract from the help sections. I would highly recommend using help to understand things which you don't understand before looking for help here because most of time you will find a good explanation and some examples to go with them on the help page

QlikView Help -> Home ‒ QlikView

Qlik Sense Help -> Home ‒ Qlik Sense

So on the right you see a list of functions you can get help on and I also highlighted Examples and results section which is initially closed, but when you click on it, it will show you some examples here.