topic Re: changing date and time format at loading in QlikView

changing date and time format at loading

sayadutt — Fri, 03 Apr 2015 13:35:17 GMT

Hi,

I am loading data from SharePoint which is of the following format.

4/3/2015 4:15 PM

How can I change it to below format when loading:

04/03/2015 16:15:00

thanks

Re: changing date and time format at loading

Gabriel — Fri, 03 Apr 2015 13:48:11 GMT

Hi,

What you want to do is to interpret incoming TimeFormat field and Format it to your desired TimeFormat (displayed Format --24hrs).

Try this

=Timestamp(Timestamp#(MyTimeStampFieldin12HrsFormat,'h:mm:ss TT') ,'hh:mm:ss')

Where MyTimeStampFieldin12HrsFormat is the incoming field from Sharepoint.

Hope this helps

Re: changing date and time format at loading

Gabriel — Fri, 03 Apr 2015 13:49:58 GMT

Hi,

I couldn't edit my previous post. You have to give this field a name

=Timestamp(Timestamp#(MyTimeStampFieldin12HrsFormat,'h:mm:ss TT') ,'hh:mm:ss') AS NewTimeFormat

Hope this helps

Re: changing date and time format at loading

buzzy996 — Fri, 03 Apr 2015 15:52:15 GMT

u can use either date#() and timestamp() functions with the required format.

Re: changing date and time format at loading

Sat, 04 Apr 2015 06:42:42 GMT

Hi,

It can works based on your system time format. If you can set 12 hours time format, it will works like this 4/3/2015 4:15 PM and If you can set 24 hours time format, it will works like this format 04/03/2015 16:15:00.