CHANGE DATE FORMATE

[#1]

Hi Grus!!!!

i have an excel sheet with datee field in formate like (DD-MON-YYYY) i.e  23-SEP-2013

but when i called this excel file in qlikview date shown lik 23/09/2013

I want to show date like as in excel sheet.. 09 shuld be shown like SEP

How to get this plz reply

defult script is

LOAD

datee,

category,

expense_name,

expense_amt

from

(ooxml,embedded,labels,table is sheet1)

if I change

LOAD

date(datee,'DD-MON-YYYY')

category,

expense_name,

expense_amt

from

(ooxml,embedded,labels,table is sheet1)

ITS GIVE "23-9ON-2013" which is not understandable

[#2]

Hi,

Use Date# function and specif the formate according  to your ned.

Thanks,

D J

[#3]

try this

Date(Date#(datefield,'DD-MMM-YYYY'),'DD/MM/YYYY') AS DATENEW

[michael_maeuser]

try this date(datee,'DD-MMM-YYYY')

[#5]

TRY THIS CODE

LOAD

date(DATE#((datee,'DD-MMM-YYYY'),'DD/MM/YYYY') AS  datee,

category,

expense_name,

expense_amt

from

(ooxml,embedded,labels,table is sheet1)

[sathishkumar_go]

HI, Try this DATE(Date#(DateField,'DD/MM/YYYY'),'DD-MMM-YYYY') Regards Sathish

[#7]

Hi 

inur expression

date(datee,'DD-MON-YYYY')

replace MON with MMM

date(datefield,'DD-MMM-YYYY')

[CELAMBARASAN]

It should be MMM not MON

LOAD

date(datee,'DD-MMM-YYYY')

category,

expense_name,

expense_amt

from

(ooxml,embedded,labels,table is sheet1)