Reputation: 1247
I want to format a datetime field but i can't figure out the syntactic. I want it to display it to look like this: "mm:dd:yy hh:mm am".
Upvotes: 0
Views: 11127
Reputation: 14020
Like this:
display replace( string( now, "99/99/99 hh:mm:ss am" ), "/", ":" ) format "x(20)"
Upvotes: 5