0

Table Builder Date Format

Lars Heuwinkel

June 20, 2024 12:53

None

Follow

Hi all
After a long time, I have started JetReport again to create a report.
The report is to be generated automatically and contains the open orders of a customer. I created the report with the TableBuilder. So far it provides the data that as needed. But the recipient of the report wants to have the date column in the format YY-MM-DD. At the moment I only get DD.MM.YYYY. How can I change the date format?
=NL("LinkFeld";"Verkaufskopf";"Buchungsdatum")
Many thanks in advance

Lars

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  CascadiaDataworks June 25, 2024 17:38

  The easiest way would be to add a new column for the other date and use Excel's TEXT function. This would provide you the most flexibility.  You still have your preferred date format, they have theirs and you only have one report.