topic Re: Date format changes in QlikView

Date format changes

sonysree88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

Could you please resolve this issue..

in my dashboard i have the date feild data like this Tue-06-2016 01.52.10 AM

am unable to extract from this date to years or months any another extraction

It would be appreciate if it solved ASAP

written expression as : Year(Date field)

Month(Date Field)

Thanks

Sonysree

Re: Date format changes

susovan — Thu, 16 Jun 2016 08:58:33 GMT

Hi sonygot,

You can try this below way,

Date(Date Field,'DD/MM/YYYY')

Re: Date format changes

sonysree88 — Thu, 16 Jun 2016 09:14:00 GMT

Hi Ghosh,

Tried it not working..data is coming from hive

Re: Date format changes

Kushal_Chawda — Thu, 16 Jun 2016 09:14:02 GMT

try this

Year(date#(trim(mid(Field,index(Field,'-',1),index(Field,' ',1))),'MM-YYYY')) as Year

month(date#(trim(mid(Field,index(Field,'-',1),index(Field,' ',1))),'MM-YYYY')) as Month

Re: Date format changes

arulsettu — Thu, 16 Jun 2016 09:29:17 GMT

maybe like this

load *,

month(date) as month,

year(date) as year;

timestamp(timestamp#(mid('Tue-06-2016 01.52.10 AM',5),'MM-YYYY hh.mm.ss TT'),'MMM/DD/YYYY') as date

Re: Date format changes

sonysree88 — Thu, 16 Jun 2016 09:36:31 GMT

Tried it not working am unable to extract something from date

How can i get the weeks from date filed

I am using like weekday(Date filed)

Re: Date format changes

antoniotiman — Thu, 16 Jun 2016 09:41:55 GMT

Try

Month(Date#('01'&PurgeChar(DateField,SubField(DateField,'-',1)),'DD-MM-YYYY hh.mm.ss tt'))

Re: Date format changes

muthukumar77 — Thu, 16 Jun 2016 09:42:06 GMT

Hi,

Date(floor(Date_Field))

Year(Date(floor(Date_Field)))

Month(Date(floor(Date_Field)))

Re: Date format changes

arulsettu — Thu, 16 Jun 2016 09:45:47 GMT

can you post sample data

Re: Date format changes

muthukumar77 — Thu, 16 Jun 2016 09:46:40 GMT

Hi,

Can you give me sample qvw file?

You can use Week(Date_Field).

Re: Date format changes

Thu, 16 Jun 2016 14:50:23 GMT

Try This

//Tue-06-2016 01.52.10 AM, Date and year

Tab1:

LOAD

Date,

Timestamp#(Left(Trim(mid(Date,5)),7),'MM-YYYY')as Date1

FROM

[\Date Field.xlsx]

(ooxml, embedded labels, table is Sheet1);

Load

Year(Date1)as DateYear,

Month(Date1) as MonthYear

Resident Tab1;