Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Datetimeadd function issue

L_T
8 - Asteroid

Hi all, 

 

I have to create a payment schedule using start date/end date and number of payments during the period. 

 

The data are:

- Start Date: Nov 5, 2017 

- End Date: Mar 5, 2024

- 39 payments

 

Using these data, I can derive the each payment occurs every 60.842105 days. 

In Excel, I can add the above number to the start date and I precisely get to Mar 05, 2024 after 39 payments.
However, when I use the datetimeadd function in Alteryx (using exactly the same parameters), my last date would Feb 02, 2024. Below the differences.

Any idea why Alteryx does not return the same schedule as Excel? And what would be the best method to fix it?

Thanks in advance 

 

AlteryxExcel
05/11/201705/11/2017
04/01/201804/01/2018
05/03/201806/03/2018
04/05/201806/05/2018
03/07/201806/07/2018
01/09/201805/09/2018
31/10/201805/11/2018
30/12/201804/01/2019
28/02/201906/03/2019
29/04/201906/05/2019
28/06/201906/07/2019
27/08/201905/09/2019
26/10/201905/11/2019
25/12/201904/01/2020
23/02/202005/03/2020
23/04/202005/05/2020
22/06/202005/07/2020
21/08/202004/09/2020
20/10/202004/11/2020
19/12/202004/01/2021
17/02/202105/03/2021
18/04/202105/05/2021
17/06/202105/07/2021
16/08/202104/09/2021
15/10/202104/11/2021
14/12/202104/01/2022
12/02/202205/03/2022
13/04/202205/05/2022
12/06/202205/07/2022
11/08/202204/09/2022
10/10/202204/11/2022
09/12/202204/01/2023
07/02/202305/03/2023
08/04/202305/05/2023
07/06/202305/07/2023
06/08/202304/09/2023
05/10/202304/11/2023
04/12/202304/01/2024
02/02/202405/03/2024

 

11 REPLIES 11
L_T
8 - Asteroid

Thanks @mceleavey, this really helps! Appreciate all your help!

mceleavey
17 - Castor
17 - Castor

no problem.gif



Bulien

Labels