topic Re: Subtracting Dates in Formula in Alteryx Designer Desktop Discussions

Subtracting Dates in Formula

Awickens — Fri, 18 Oct 2019 06:21:36 GMT

Hi there,

New to using alteryx and I'm having some difficulty with the following formula and what date function to use:

(30/09/2019-1/10/2018)/365*0.1

It's currently not bringing up the days between those dates and these dates are a once off in a formula (not in the data input).

Many thanks for your help!

Re: Subtracting Dates in Formula

TonyA — Fri, 18 Oct 2019 06:42:11 GMT

It looks like you are trying to calculate the number of days between two dates. Here's an example of a formula that does that in Alteryx:

DateTimeDiff("2019-09-30","2018-10-01","days")

With this function, you have a number of options for time periods, ("seconds", "minutes", "hours", etc.). Here's a link in Academy to some interactive training on date functions: https://community.alteryx.com/t5/Interactive-Lessons/DateTime-Functions/ta-p/98952. If you haven't done so already, I would recommend you go through as many of those introductory videos as you can. I found them very helpful when I started learning Designer.

Re: Subtracting Dates in Formula

RolandSchubert — Fri, 18 Oct 2019 06:43:37 GMT

Hi @Awickens ,

you have to convert the dates to dateformat in the first step, the you can use DateTimeDiff formula to calculate the difference in days and multiply that difference by 0.1. I've attached a sample workflow. Hope this is helpful.

Best regards

Roland

Re: Subtracting Dates in Formula

Awickens — Mon, 21 Oct 2019 01:23:58 GMT

The date formula worked perfectly! Thanks @TonyA

Re: Subtracting Dates in Formula

TonyA — Mon, 21 Oct 2019 03:34:56 GMT

Glad that worked out for you @Awickens . Please mark any of the responses that answered your question as solutions so others with similar problems can find them. Thanks!