Date and time from TimeStamp

[#1]

Hi,

How can return only the date from a Time Stamp field.

Time Stamp return: 1/1/2011 4.44 PM for example!

It will be great if i can have the time seperated as well.

Note that I am loading the data from QVD.

[m_woolf · Accepted solution]

floor(TimeStamp) will give data

TimeStamp - Floor(TimeStamp) will give Time

Both will have to be formatted.

[#3]

you can truncate the time using function:

DayStart()

[#4]

An do you know how to format the time..?

Thxs

[m_woolf]

use the timestamp function

[#6]

Thxs..

[#7]

Hi,

I am getting wrong nrs on the time ..

would you please explain how to frmat the time from TimeStamp?

Thxs

[m_woolf]

What wrong numbers are you getting?

[#9]

Example of time: 0.60395833332586 while I want it to show as hh:MM AM or something simillar

Thxs

[m_woolf]

For example:

=timestamp(YourField,'h:mm:ss TT')