Challenge #258: Relatively Old

[dema3313]

My solution

[estherb47]

This is the most Date functions I've used in a single workflow!

Spoiler

[owenbower]

Solution: 

[dylan3011]

fun

[EricSchreiner]

Couldn't attach a screenshot to this one for a spoiler unfortunately

[Eilean_]

Didn't use datetimeadd 3 days for Juliette's birthday but used generate rows to get the next 'Friday' 

[Ericito]

Aaron makes it easy to understand!

[monica24]

🙂

[BodieR]

Took a second, but figured it out!

[dhavaldoshi]

How to do it as a Beginner?

Things to learn:

• Nested Function: Alteryx follows sequential processing under a formula tool, but to avoid mistakes in forgetting calculations it is better to use a function within another and complete the operation within single formula
• Grouping similar functions: Similar algebraic operations should be grouped within same tool/tool container 
• Data Type: While creating a new field in formula tool, always ensure the correct data type; in this case it would be 'Date'

Spoiler

Innovation:

Calculation of Days to Friday is agnostic of what day the start is

MOD function has addition metric of 7 - Day of Week (5) in this case