Question

Photo of Jeremy Turgeon

0

Reporting Date Fields

1

When running a report with a date custom attribute or a birth date it looks fine within Rock (e.g. 11/1/2015) but displays incorrectly once exported to Excel. Birthdate comes out looking like (11/1/2015 12:00:00 AM) which is close, but I've never wanted or needed to know the exact minute or second a congregant was born. General attribute dates are even worse and display as (2015-11-1T00:00:00.0000000). Tried to use Lava to render it properly with {{ MyColumnName | Date:'M/d/yyyy' }} but it exports to Excel completely blank.

  • Photo of Matthew Meekins

    0

    This may not be an answer for you depending on how much data you have to process, but it's been pretty easy for me when I have to export reports with dates to Excel to just highlight the entire date column and change the formatting in Excel. It's usually under the Format column I think (I'm using Google Sheets so I'm not sure exactly what it's called in Excel).

    • Jeremy Turgeon

      Jeremy Turgeon

      It is possible to format the information in Excel but since I'd end up doing this for most of the staff who aren't fluent in Excel it isn't ideal. I'll probably have to submit a bug for the Lava portion and a feature request for the rest.