how do I convert a date time field to a date field and the time section into seconds instead of hours, minutes and seconds
Posted on 2014-10-18
I have a date time field that I need to split into a date and a time field, and I also have to change the time from hours, minutes and seconds into total seconds, based on hours minutes and seconds. THe system that I am importing data into does not use hours minutes and seconds, just seconds.
I will be formatting the data in excel and then importing.