topic Re: Date Function (03-Jun 06.32) in QlikView

Date Function (03-Jun 06.32)

Wed, 03 Jun 2015 15:54:11 GMT

Hi All,

Is anyone able to help me get this into a date format of:

03/06/2015 06:32

It is currently text in my file.

Thanks in advance

Re: Date Function (03-Jun 06.32)

Wed, 03 Jun 2015 15:55:29 GMT

03-Jun 06.32

is the text I currently have

Re: Date Function (03-Jun 06.32)

Colin-Albert — Wed, 03 Jun 2015 16:56:15 GMT

Does your existing date have a year?

Use Date#() to format the text being input, then wrap a Date() function around this to get the required output format.

If your input date is in a field called DateIn and is formatted as 03-Jun-15 06:32

Date( Date#(DateIn, 'DD-MMM-YY hh:mm') , 'DD/MM/YYYY hh:mm')

The text in bold is setting the format of the input date DateIn.

The rest of the text is setting the output format.

Re: Date Function (03-Jun 06.32)

MarcoWedel — Wed, 03 Jun 2015 19:34:51 GMT

Hi,

if you don't have a year in your dates and like to use e.g. the current year, then one solution could be:

Timestamp(SetDateYear(Timestamp#('03-Jun 06.32','DD-MMM hh.mm'),Year(Today())))

hope this helps

regards

Marco

Re: Date Function (03-Jun 06.32)

MarcoWedel — Wed, 03 Jun 2015 19:53:52 GMT

hope this helps

regards

Marco

Re: Date Function (03-Jun 06.32)

maxgro — Wed, 03 Jun 2015 19:57:50 GMT

maybe

date(

date#(

subfield('03-Jun 06.32', ' ', 1) & '-' & year(today()) & ' ' & subfield('03-Jun 06.32', ' ', 2) ,

'DD-MMM-YYYY hh.mm'),

'DD/MM/YYYY hh:mm')

in image the intermediate results

starting from subfield (top); I added the year

then date#(subfield.....

and last date(date#(subfield.... at the bottom

here for detail on date and date#

Get the Dates Right

Re: Date Function (03-Jun 06.32)

Thu, 04 Jun 2015 09:18:37 GMT

Thanks for the help, I have solved this by concatenating the day month and year(today()) with the hh:mm to get the full date.

Re: Date Function (03-Jun 06.32)

MarcoWedel — Thu, 04 Jun 2015 10:23:29 GMT

Very good.

Please close your thread

Thanks

Regards

Marco