Hi, I have the date format as ‘MM/DD/YYYY HH:MM:SS’ in the DB and I am using this object in the Prompt, but I want see this date in Prompt as ‘MM/DD/YYYY’ only… Please help me in this. jr8122 (BOB member since 2008-08-13)

Truncate a date..

system September 2, 2008, 4:42pm 2

It doesn’t work that way. Here’s an older topic where various options were discussed:

Dave Rathbun (BOB member since 2002-06-06)