Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

CHANGE DATE FORMATE

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

Tags (1)
7 Replies
Not applicable

Re: CHANGE DATE FORMATE

Hi,

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

Thanks,

D J

Not applicable

Re: CHANGE DATE FORMATE

try this

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

michael_maeuser
Contributor III

Re: CHANGE DATE FORMATE

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

Not applicable

Re: CHANGE DATE FORMATE

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
Contributor III

Re: CHANGE DATE FORMATE

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

Not applicable

Re: CHANGE DATE FORMATE

Hi 

inur expression


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


replace MON with MMM


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

Re: CHANGE DATE FORMATE

It should be MMM not MON

LOAD

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

category,

expense_name,

expense_amt

from

(ooxml,embedded,labels,table is sheet1)

Community Browser