topic Re: Date text Change in QlikView

Date text Change

pgalvezt — Fri, 01 Apr 2016 13:38:47 GMT

Hello,

I need to change monday 15th february 2016 to this 15-02-16.

Pls help!

Thanks!

Re: Date text Change

agustinbobba — Fri, 01 Apr 2016 13:43:54 GMT

Hi Pablo!

Try this!..

DATE(MakeDate(YEAR(Date), MONTH(Date), DAY(MDate)),'DD-MM-YY') AS Date

Best regards!

Agustin.

Re: Date text Change

MK_QSL — Fri, 01 Apr 2016 13:51:28 GMT

Is it monday 15th february 2016 or 15th february 2016?

I mean WeekDayName is there or not?

Re: Date text Change

pgalvezt — Fri, 01 Apr 2016 13:58:19 GMT

Hi,

I put a sample for better understanding.

Thanks!

Re: Date text Change

Fri, 01 Apr 2016 13:59:26 GMT

Date (

MakeDate (

Year (Date (Date# (Mid ('monday 15th february 2016', Index ('monday 15th february 2016', ' ', 2) + 1), 'MMMM YYYY'))),

Month (Date (Date# (Mid ('monday 15th february 2016', Index ('monday 15th february 2016', ' ', 2) + 1), 'MMMM YYYY'))),

KeepChar (SubField ('monday 15th february 2016', ' ', 2), '0123456789')

'DD-MM-YY')

Re: Date text Change

MK_QSL — Fri, 01 Apr 2016 14:01:42 GMT

Sorry but Can you post 2-3 lines only in English... I don't understand this language... Sorry For this..!

Re: Date text Change

jonathandienst — Fri, 01 Apr 2016 14:09:35 GMT

If dateField contains a date like: monday 15th february 2016

=Date(Date#(TextBetween(dateField, ' ', 'th') & '-' & SubField(dateField, ' ', 3) & '-' & SubField(dateField, ' ', 4), 'dd-MMMM-yyyy'))

Re: Date text Change

agustinbobba — Fri, 01 Apr 2016 14:09:47 GMT

Pablo,

La fecha viene en ese formato desde la fuente?, creo que la solución de Ed Hilsinger es correcta, vas a tener que crear la fecha desde cero. A no ser que sea en formato numero que mi solución también es correcta.

Saludos,

Agustin

(The date source came in this format?, the solution of Ed hilsinger is correct, you need to make the date from scratch. but if the date format is as a number you can use my solution as well)

Re: Date text Change

Fri, 01 Apr 2016 14:55:11 GMT

Hello

Please check if the attached prototype is ok for you.

Re: Date text Change

psankepalli — Fri, 01 Apr 2016 15:29:12 GMT

Hi,

Please find the attached QVW, which converts the date to your required format.

First I created variable

vDate =Date#(TextBetween(InputDate, ' ', 'th') & '-' & SubField(InputDate, ' ', 3) & '-' & SubField(InputDate, ' ', 4), 'dd-MMMM-yyyy')

then re-used that variable into text box

=Date(vDate,'DD-MM-YYYY')

hope this will solve your problem

Thanks

Re: Date text Change

psankepalli — Fri, 01 Apr 2016 15:29:50 GMT

Sorry Attachment missing

Re: Date text Change

Kushal_Chawda — Fri, 01 Apr 2016 15:45:23 GMT

date(date#(purgechar(SubField(InputDate,' ',2),'th') &'-'& mid(InputDate,Index(InputDate,' ',2)+1),'DD-MMMM YYYY'),'DD-MM-YYYY') as Date

Re: Date text Change

pgalvezt — Fri, 01 Apr 2016 17:11:44 GMT

Hello!

Thanks for your replying I think the trouble is the long of data. I cant reach the information with your code in my app.

I attached a sample where i will try to explain the situation in my languague.

Thanks!

Re: Date text Change

Kushal_Chawda — Fri, 01 Apr 2016 17:15:23 GMT

Yes, Code will remain the same. Just apply the above logic with your data and see

Re: Date text Change

pgalvezt — Fri, 01 Apr 2016 17:30:01 GMT

Kush,

I put your cod into my sample qv, Question: I have to edit just the numbers? Date field show nothing...

Re: Date text Change

settu_periasamy — Fri, 01 Apr 2016 17:38:49 GMT

Hi,

Try this

Date(Date#(replace(SubField('$(Fecha Inicio)',', ',-1),' de ',' '),'DD MMMM YYYY'),'DD_MM_YYYY') as [Fecha Inicio],
Date(Date#(replace(SubField('$(Fecha Termino)',', ',-1),' de ',' '),'DD MMMM YYYY'),'DD_MM_YYYY') as [Fecha Termino]

Read Excel and sort the data

Edit:

Environment variables should be in your format..

SET DateFormat='DD-MM-YYYY';
SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';
SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

Re: Date text Change

pgalvezt — Fri, 01 Apr 2016 17:40:36 GMT

Thanks Guys!

Re: Date text Change

Kushal_Chawda — Fri, 01 Apr 2016 17:47:49 GMT

I think in your case try like this

date(date#(SubField('$(Fecha Inicio)',' ',2)&'-'& SubField('$(Fecha Inicio)',' ',4)&'-'& SubField('$(Fecha Inicio)',' ',6),'DD-MMMM-YYYY'),'DD-MM-YYYY') as Date,