[Bug] Writing Dates to Excel

More
1 year 5 months ago #24817 by prashant
Hellos,
I am 5.12. I am forced to use a single quote to write dates in excel 

1. IF I write a date directly to excel it's written in excel number format , but if I concat it with ' , it comes out fine (without the ')
2. When I try to write below field to a excel column , only first date is written , but again if I concat the same with ' , it works fine 2025-02-10;2025-02-11;2025-02-12;2025-02-13;2025-02-14;2025-02-17;2025-02-18;2025-02-19;2025-02-20;2025-02-21;2025-02-24;2025-02-25;2025-02-26;2025-02-27;2025-02-28

See this example , problem is second long string not being written
www.loom.com/share/06c7c0845b014c0081fdd...40-88ea-67efecf0416a
 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
1 year 5 months ago #24819 by Peter.Jonson
Not sure I understand the the issue to honest.

In order to load date into excel you have to do two things

Use Format Date function and apply format to column





In some cases it might be necessary to use ` character
For example to avoid issues with leading zeros.

Unfortunately there is much we can do about it.

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
1 year 5 months ago #24820 by prashant
In one CELL , the following entry has to go but only the first part goes "2025-02-10", others are automatically cut off

2025-02-10;2025-02-11;2025-02-12;2025-02-13;2025-02-14;2025-02-17;2025-02-18;2025-02-19;2025-02-20;2025-02-21;2025-02-24;2025-02-25;2025-02-26;2025-02-27;2025-02-28
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
1 year 5 months ago #24822 by Peter.Jonson
Thank you for the clarification, we will check it for you

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
1 year 5 months ago #24823 by Peter.Jonson
FYI: That was fixed

Peter Jonson
ETL Developer
The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save