amphi-ai/amphi-etl

Date Conversion tool

Closed this issue · 3 comments

simonaubertbd commented

Hello,

Converting text to date or date to text is a very common task. We can do that through formula but it's not that straightforward since there are many formats. Having a visual help would be a huge advantage.

Here an example :
image

We can even do better with the ability to select different fields at once.

Best regards,

Simon

tgourdel commented

Hi @simonaubertbd, I've introduced a DateTime Converter component in the last version (0.6.0). Hope it works well, let me know if you encounter any issues or have any feedback

simonaubertbd commented

@tgourdel Thanks, really nice tool that will simplify life with dates. But you know me, yep, I have three feedbacks 😄
-maybe a way to choose the name of the new column when new column is checked
-when it's date to string=>only retrieve date fields
-when it's date to string=> I noticed the field is an "object" and not a string. Don't know if it's a bug or feature.
-I'm not sure to understand the impact of the language drop down menu?

Do you want me to create distinct issues for all of that ?

Best regards,

Simon

  • 👍1
tgourdel commented

Thanks Simon, fair points for the first 2 :D
The object type is definitely a miss, should be a string!
The language is needed (if i'm not mistaken) for the formats using month and days names (January vs Janvier)