Multirow Date Formula

Hey Guys,

I am trying to write a formula to add dates for example (see the picture below) -

I have all rows till Date and I am trying to get the new date column, (Basically adding 7 days if there is a null value in cht_itemcode)

I have been using this formula but it doesn't seem to work -

IF IsNull([cht_itemcode]) THEN (DateTimeAdd([Row-1:Date],7,"Days")) ELSE [Row-1:Date] ENDIF

Please let me know if there is a solution.

Thank you

Developer Tools

Output

Accepted answers

DavidP

ok, I think this now does what you want.

The formula is

if !isnull([Row-1:new date]) then
if isnull([cht_itemcode]) then
datetimeadd([Row-1:new date],7,'days')
else [Row-1:new date]
endif
else [Date]
endif

new date.png

new date.yxmd

All comments

DavidP

You need to convert both date and newdate to the standard datetime format with datetime parse tools. The standard date format is '2018-11-18'

San_N

Yup, I have it in the same format in the alteryx tool.

DavidP

You can also use a formula tool to change the date format and then change the datatype with a select tool like this

DavidP

Ok, have a look at attached workflow. Formula is the same as yours. I guess new date is the field created by your multi-row formula. Did you set the type as date?

new date.yxmd

San_N

It still doesn't work.

Can you give me a formula to get new date column from Date column. that works.

The formatting is right.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703