topic Re: Convert Time Stamp in QlikView

Convert Time Stamp

Wed, 19 Mar 2014 10:25:35 GMT

Hi,

Could someone kindly assist me with a time stamp conversion problem I have. I have a field (Received Date) which has a time stamp, and an example is : 13.3.2014 13:28:16 . I would like to convert this to a date and have been trying the following:

Date(Floor(TimeStamp#([Received Date],'DD.MM.YYYY hh:mm:ss')),'DD.MM.YYYY') as [Received Date],

For some strange reason it is not converting the time stamp and is returning values of "-" in the Received Date field.

Help please .

Thank you Herbiec 09

Re: Convert Time Stamp

PrashantSangle — Wed, 19 Mar 2014 10:29:57 GMT

Hi,

Try this

Date(Floor(TimeStamp(TimeStamp#([Received Date],'DD.MM.YYYY hh:mm:ss'),'DD.MM.YYYY hh:mm:ss')),'DD.MM.YYYY') as [Received Date],

you can do

Date(Floor([Received Date]),'DD.MM.YYYY') as [Received Date],

Regards,

Re: Convert Time Stamp

amit_saini — Wed, 19 Mar 2014 10:30:28 GMT

Hi Herbert,

Please check if this is working for you: (Goto Numbers--->Select your Field ---->>>Select Time stamp option

Thanks,

Re: Convert Time Stamp

CELAMBARASAN — Wed, 19 Mar 2014 10:37:56 GMT

13.3.2014 13:28:16 looks like it will display the 01.01.2014 01:01:01 as 1.1.2014 1:1:1 if it is the case then your expression would be

Date(Floor(TimeStamp#([Received Date],'D.M.YYYY h:m:s')),'DD.MM.YYYY') as [Received Date]

Re: Convert Time Stamp

MK_QSL — Wed, 19 Mar 2014 10:38:17 GMT

=Date(FLOOR(Timestamp#([Received Date],'DD.M.YYYY hh:mm:ss')),'DD.MM.YYYY')

Re: Convert Time Stamp

er_mohit — Wed, 19 Mar 2014 10:43:50 GMT

Try this in text object

=Date(Date#('13.03.2014 13:28:16','DD.MM.YYYY hh:mm:ss'),'DD.MM.YYYY')

so in script try this

Date(Date#([Received Date],'DD.MM.YYYY hh:mm:ss'),'DD.MM.YYYY') as [Received Date]

or try this way

If(len([Received Date])>0,Date(Date#([Received Date],'DD.MM.YYYY hh:mm:ss'),'DD.MM.YYYY') )as [Received Date]

Re: Convert Time Stamp

Wed, 19 Mar 2014 10:59:52 GMT

Hi,

Try this

=Date(Date#([Received Date],'DD.MM.YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')

Regards

Kumar

Re: Convert Time Stamp

Wed, 19 Mar 2014 11:10:43 GMT

Hi,

Got it working with:

Date(Date#(Left([Received Date],Index([Received Date],' ')-1),'D.M.YYYY'))

Hope this helps