Show Date/Time fields as only Date?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-19-2014 04:28 AM
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.
- Labels:
-
User Interface (UI)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-19-2014 05:40 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-19-2014 06:31 AM
Thank you for this very good answer, I have exactly adviced this approach, to the customer.
