Showing the date with time in a text box from a field

[#1]

Hi

I have date field with time. When I am trying to show the Min(Date)[With Time]. It is displaying the something line 40891.191. I want to display the date value as it is(With time). May I know how to achieve this?

Thanks,

Attitude

[henrikkold · Accepted solution]

You need to format the Timestamp - timestamp(min(Date),'DD-MM-YYYY hh:mm:ss')

[#3]

Hi Henrik

Thanks alot! I used this before but I could not able to recall it.

Many thanks,

Attitude