Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You need to format the Timestamp - timestamp(min(Date),'DD-MM-YYYY hh:mm:ss')
You need to format the Timestamp - timestamp(min(Date),'DD-MM-YYYY hh:mm:ss')
Hi Henrik
Thanks alot! I used this before but I could not able to recall it.
Many thanks,
Attitude