show only the date from date/time field

[shembop]

Is there a way in Reporting, and on forms to show only the date on a field that is in a date/time format? We have projects etc. that have a Planned start and end dates, but they are in the date/time format. Without messing with the underlying data, can we define how this is displayed in forms and reports?

[shane_bourasa]

I would think that you just create a new field on the table with date datatype. You can write a script to take the current value for the date/time field and set the new date field in your date format.

[jarodm]

I haven't had a need to do this, but I would first experiment with the dictionary attributes for the date/time field.

format
format name
any numeric field
Specifies a named format to use instead of the standard numeric formatting. Options are:
glide_duration: formats a time specified in milliseconds as ddd hh:mm:ss.
none: disables automatic number formatting (for example, changes 2,500 to 2500).

Source: Available attributes

JarodM

[SanaPR]

8 Years later, did anyone figure out a way to do this? 
Was this achieved without backend changes..?