INTERACT FORUM

More => Old Versions => Media Center 15 (Development Ended) => Topic started by: djharry on August 29, 2010, 03:45:38 pm

Title: Date Field - I don't need the time stamp
Post by: djharry on August 29, 2010, 03:45:38 pm

Is there an option to remove the time stamp from my date field, and my views? When I show records for a certain date I don't want to see 10 different entries for one day as individual folders because they all have a different time stamp. I can send pics if needed.

Thanks,
_hd

Title: Re: Date Field - I don't need the time stamp
Post by: rick.ca on August 29, 2010, 05:23:40 pm

Use FormatDate() in an expression column or field. For example: FormatDate([Date, 0], date)—the "0" parameter displays [Date] as a number; FormatDate() with the "date" parameter displays that number according to your regional date format setting.

When entering an expression using the Expression Editor (which may be an expression column, when creating a custom expression field, a smartlist, etc.) a tooltip for the expression will the explain the options available.