Timestamp, Datestamp, Time, Date etc etc etc

[dmac1971]

Need a definitive guide on extracting date and time from a timestamp, having diffs with it!

Data comes in from a csv file, in the file the data is displayed as "01/07/2015  06:53:00", once imported into QV without any changes the format changes to "01-07-2015  06:53:00".  So it looks like QV has recognised the data as a date etc.

To extract a workable date I'm using :

Date(Timestamp#([Start Date and Time],'DD-MM-YYYY')) As StartDate,

And this seems to work ok as I can then generate my calendar etc.  How do I extract the time, and just the time?

[settu_periasamy]

Try this with 2 space between yyyy and hh

=timestamp(timestamp#(field,'DD/MM/YYYY  hh:mm:ss'),'hh:mm:ss')