Enriching your dataset by weeks...

[Atabarezz]

When enriching your date data, week information is pretty critical, I suggest adding %w to the format stings as well..

Several month based expressions can also be made weekly, data time first of week #31, last of week #45 etc....

Also came across a lot of questions at our community on how to turn week based data...

Writing the formula is obvious (Ceil(DateTimeDiff([Today],[Date],'days')/7))

but having a DateTimeDiff([Today],[Date],'weeks') is preferable don't you think?

Cheers

[Atabarezz]

Weeks needed here...

[SeanAdams]

Hey @Atabarezz

While I agree with the need for weeks - I think that what's needed is a little more fundamental.

From looking at all the ways that you can manipulate dates in Alteryx - there's the % notation, there's the date-part notation, etc.   Through all this, there's a lack of treatment for weeks, or milliseconds.   Finally - dates are stored in Alteryx as strings which is very different than most other platforms which store dates as floating point numbers.

So - from looking at the ideas related to dates - there seems to be a need to go back to basics and refactor the treatment of dates to make this consistent across the entire platform. 

Have a look at: 

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Refactor-Date-time-treatment/idi-p/46420

HEre's a list of 23 other ideas in the idea board all related to date-time improvement too, and the authors of these ideas have been tagged out of courtesy

@DultonM @braxtone @Philip @AshokBhatt @CSchrader @dawid_nawrot @jdunkerley79 @joe_lipski @ChadB @nicholas_carstens @GGuenther @AndrewW @RachelW

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Refactor-Date-time-treatment/idi-p/46420

https://community.alteryx.com/t5/Alteryx-Product-Ideas/DateTime-Tool-Enhancements-Convert-Multiple-F...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Time-Based-Function/idi-p/4842

https://community.alteryx.com/t5/Alteryx-Product-Ideas/More-forgiving-evaluations-of-Date-and-DateTi...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Have-a-way-to-easily-get-date-parts-out-of-a-...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/DateTimeTrim-Function-Add-Week-Trimming/idi-p...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Add-DateTime-type-with-milliseconds/idi-p/200...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Alteryx-making-dating-easier/idi-p/20625

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Make-d-and-m-in-DateTimeFormula-work-if-no-le...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Null-Date-Check/idi-p/13116

https://community.alteryx.com/t5/Alteryx-Product-Ideas/CreateDate-Function/idi-p/55171

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Update-existing-field-in-DateTime-tool/idi-p/...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Allow-Date-DateTime-Time-output-from-Regex-Pa...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Update-existing-field-in-DateTime-tool/idi-p/...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/DateTimeFirstOfWeek-Formula-Function/idi-p/14...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Date-Time-Formatting-Beginning-with-2-Digit-Y...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Have-a-Time-Question-in-Analytic-Apps/idi-p/1...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Impute-Dates/idi-p/1509

https://community.alteryx.com/t5/Alteryx-Product-Ideas/DateTimeTrim-for-Year/idi-p/35805

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Next-potential-improvement-to-formula-tools/i...

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Improvements-to-the-Select-Tool/idi-p/33834

https://community.alteryx.com/t5/Alteryx-Product-Ideas/random-inputs/idi-p/54222

https://community.alteryx.com/t5/Alteryx-Product-Ideas/Field-Sumary-tool-should-report-all-data-type...

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!