Skip to main content
Question

How do I export a table from Business View into Excel that respects user selected columns? How do I export a properly formatted date?

  • Aug 16, 2021 1:11 PM UTC
  • 2 replies
  • 96 views

e.g. including hidden columns manually selected by user to be visible (currently columns with attribute hidden: true do not seem to export irrespective of user selection)

 

2 replies

in respect to properly formatted dates: users see in xls export '1630886400000' instead of '2021-09-06'


  • Level 0
  • Nov 23, 2021 9:46 PM UTC

Hi Alex,

 

not quite sure if this is an option for you but a workaround could be that you concatenate the date like the following:

DAY(timestamp)||MONTH(timestamp)||YEAR(timestamp). Let me know if this worked.

 

Best

Kevin