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?

  • August 16, 2021
  • 2 replies
  • 15 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

  • Author
  • Level 4
  • August 16, 2021

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


  • Level 0
  • November 23, 2021

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