Creating a new field with a data and adding to that date

Question

Hi,

Can someone please help me with the following?

I want to add a new field for dates to my data. Dates are not part of my input data.

I want to be able to have "10/27/2019" for the date field for this week and then next week add 7 days so the field reads "11/3/2019". Additionally, I want the field to be a date not a string.

I've tried using the formula and the date time tools but I cannot find a way to add the 7 days for next week's data.

Thank you!

Sam

JoshuaGostick · Accepted Answer

Hi @delcarpiosamuel

You could use the DateTime tool again to format the standard yyyy-MM-dd date format to a different format like MM/dd/yyyy.

In this case, configuring the DateTime tool like below should solve your issues.

However, note that Alteryx will treat 10/27/2019 as string data instead of date data.

Josh

CharlieS · Accepted Answer

To convert a date field to the MM/DD/YYYY format, use the following expression:

DateTimeFormat([Date],"%m/%d/%Y")

This can be incorporated into the formula you already have:

DateTimeFormat(ToDate(42765),"%m/%d/%Y")