Date Formats - help wanted

[#1]

I have dates that are being displayed as numbers but can't find a way to format them as dates (see attached).  The only place I know to do this formatting is in Properties/Number.  But the date is not listed as a posible selection to format.  The Date only shows up in the Dimension and Presentation tabs and I can't find a way to format it as a date in either of those tabs.  Any suggestions?

[#2]

Hi Denise,

If you edit the dimension (or create a Calculated Dimension), you can use:

=Date([Gas Day],'DD/MM/YYYY')

Or you may have to convert to date format:

=Date#([Gas Day],'DD/MM/YYYY')

Hope this helps!

[#3]

date(41738) will give you 4/9/2014

In you script do 

date(datefield, 'MM-DD-YYYY') as datefield,

[Anonymous]

You can format it in the document settings under number

or you format it using the date function date(yourdate)

[Greg_Hood]

Hi Denise, it looks like the gas day field is being imported purely as a number.  The best way to solve this would be in your load script, essentially tell QlikView that you want this field to be a date, not purely a number.  You can do that by using the date() function in the script.  QlikView tries to interpret values or fields when it loads them, but sometimes it is safer to specify what you want.

LOAD * ,

date(OldDate) as DateNoHash;

load * Inline [

OldDate

41738

41739

41740

41741];

See the attached simple example which may help you.    Thanks for choosing QlikView!

[cfz]

Hi Denise,

You can for instance use the date functions in the script and transform the values before saving them or or you can use them when creating a calculated dimension already in the chart

In this post the date functions are explained in detail

http://community.qlik.com/message/411955#411955

I hope it helps you.

Kind regards

Carlos

[#7]

thank you very much