changing date and time format at loading

[sayadutt]

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

[Gabriel]

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

[Gabriel]

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

[buzzy996]

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

[#5]

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.