Hello,
I would like to suggest an improvement for the extract date&time fields node.
When you are choosing the localisation setting, there is no way to understand what it implies, such as first day of week, and how to define the first day of the week (something similar to WEEKNUM function in Excel).
It would be useful to make all this information explicit in the circled blank space of the configuration window.
Have a nice day,
Raffaello
Linkedin
Hi @lelloba -
Thanks for the suggestion!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
I would agree - that would help identify “the week of” starting on Mondays (or whatever) so that downstream can group and summarize into weekly data. I would also add “broadcast month” that television and traditional advertisers use.
Nice suggestion you have given
I support the proposal and would like to extend it. As the localization affects more than one extracted part, it can happen that a strange combination is desired which is not easy to find based on the country selection.
What if an e.g.: “Localization based calculation” checkbox would be set as default? Unchecking it would reveal the manual settings per added fields where applicable.
An even better but more complex solution would be to add the manual setting fields permanently where the default value would be e.g. “Localization based”. Then the “Localization based calculation” checkbox would not be needed.
