Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Timestamp

I need to get the timestamp M/D/YYYY h:mm:ss[.fff] TT from today() but I cant get it to give me the hours minutes seconds part.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

In a Text Object

     =Timestamp(today(),'M/D/YYYY h:mm:ss[.fff] TT')

displays

    9/11/2017 12:00:00 AM



But


=Timestamp(now(),'M/D/YYYY h:mm:ss[.fff] TT')


displays


     9/12/2017 4:33:18 PM


View solution in original post

2 Replies
Anonymous
Not applicable
Author

In a Text Object

     =Timestamp(today(),'M/D/YYYY h:mm:ss[.fff] TT')

displays

    9/11/2017 12:00:00 AM



But


=Timestamp(now(),'M/D/YYYY h:mm:ss[.fff] TT')


displays


     9/12/2017 4:33:18 PM


Anonymous
Not applicable
Author

Thank you !