INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Date Field - I don't need the time stamp  (Read 801 times)

djharry

  • Regular Member
  • Recent member
  • *
  • Posts: 5
  • karmapa chenno
Date Field - I don't need the time stamp
« 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
Logged

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Re: Date Field - I don't need the time stamp
« Reply #1 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.
Logged
Pages: [1]   Go Up