Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Use Date# function and specif the formate according to your ned.
Thanks,
D J
try this
Date(Date#(datefield,'DD-MMM-YYYY'),'DD/MM/YYYY') AS DATENEW
try this date(datee,'DD-MMM-YYYY')
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)
HI, Try this DATE(Date#(DateField,'DD/MM/YYYY'),'DD-MMM-YYYY') Regards Sathish
Hi
inur expression
date(datee,'DD-MON-YYYY')
replace MON with MMM
date(datefield,'DD-MMM-YYYY')
It should be MMM not MON
LOAD
date(datee,'DD-MMM-YYYY')
category,
expense_name,
expense_amt
from
(ooxml,embedded,labels,table is sheet1)