Convert Date/Time Field to include Seconds
I have a date/time field that shows MM/DD/YY HH:MM, what I need is to also include the Seconds. I tried converting my date/time field into a formula field, using: Second(ToTimeOfDay([Date Modified]))...
Forum Discussion
I would like to jump on to the original post also. I have Time Stamp data, DD-MM-YYYY HH:MM:SS, that I must keep the seconds on. It would not be ideal to have to take the original, raw data and strip the date into a column and the time into a column since I have to graph this data with a complete time stamp - not ideal to have 2 columns referenced to create a single axis.
It appears that I will need to store the data in QuickBase, but export it to a data analysis program to graph as there are 10,000 elements per column I need to show, and then save the graph or any manipulated data. We can somehow combine the data and time columns on export, but it seems easier to have it stored correctly in the first place.
Thoughts?
It appears that I will need to store the data in QuickBase, but export it to a data analysis program to graph as there are 10,000 elements per column I need to show, and then save the graph or any manipulated data. We can somehow combine the data and time columns on export, but it seems easier to have it stored correctly in the first place.
Thoughts?