topic Re: CHANGE DATE FORMATE in QlikView

CHANGE DATE FORMATE

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: CHANGE DATE FORMATE

Thu, 19 Sep 2013 09:37:17 GMT

Hi,

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

Thanks,

D J

Re: CHANGE DATE FORMATE

Thu, 19 Sep 2013 09:37:24 GMT

try this

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

Re: CHANGE DATE FORMATE

michael_maeuser — Thu, 19 Sep 2013 09:37:50 GMT

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

Re: CHANGE DATE FORMATE

Thu, 19 Sep 2013 09:43:41 GMT

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)

Re: CHANGE DATE FORMATE

sathishkumar_go — Thu, 19 Sep 2013 09:52:22 GMT

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

Re: CHANGE DATE FORMATE

Thu, 19 Sep 2013 09:58:42 GMT

inur expression

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

replace MON with MMM

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

Re: CHANGE DATE FORMATE

CELAMBARASAN — Thu, 19 Sep 2013 10:03:35 GMT

It should be MMM not MON

LOAD

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

category,

expense_name,

expense_amt

from

(ooxml,embedded,labels,table is sheet1)