question Show Date/Time fields as only Date? in Developer forum

Show Date/Time fields as only Date?

poulsenniels — Fri, 19 Sep 2014 11:28:04 GMT

We have fields in the database defined as Date/Time … is it possible to have the data shown on the screen with only date?

It's because we get a date from supplier as e.g. "20-09-2014" which mean that the supplier will deliver on this day ("20-09-2014 23:59:59" at latest to be precise).

On the screen "20-09-2014" is shown as "20-09-2014 00:00:00" — this is both erroneous and confusing.

We have been warned to change the datatype in the database, since it is a standard SNOW field.

Re: Show Date/Time fields as only Date?

Mark Stanger — Fri, 19 Sep 2014 12:40:17 GMT

Unfortunately you can't. You need to use a 'date' field for that. You also can't switch the type from date/time to date because they're not compatible at the database layer. You'll need to recreate the field as a date field or create a second field as a date field and populate the date there if you want to display only the date.

Re: Show Date/Time fields as only Date?

Stig Brandt2 — Fri, 19 Sep 2014 13:31:38 GMT

Thank you for this very good answer, I have exactly adviced this approach, to the customer.