Date Time Manipulation

[DeanLascota]

Hi everyone,

I am fairly new with the application. I am working on a report where I need to filter data which is dependent on dates. I need to get rows of data where the date is less than a specific amount of days from current date. I am using the formula tool and the DateTime functions but I keep getting no to failed results.

Thank you in advance!

[binuacs]

@DeanLascota use the DateTimeAdd() and DateTimeToday() functions for your use case

[alisonpitt]

@binuacs 's method is how I would do it.

You should also make sure that you are working with the right data types for your dates. It's not uncommon for Alteryx to read in dates from an input tool as strings, which only work in the DateTime functions if they are in the standard ISO format. If the dates are formatted as strings, you can use the DateTime tool to convert them. Good luck! 

[DeanLascota]

Thank you for your help. I will update you as I progress. Appreciate you guys :)