Apply Formula on dates and update the new column

[Lakshmikanth_2021]

I need apply the date formula on column 'Created On' on input file and get the desired 'output' in Alteryx. 

Formula: If the 'created on' is in the last 7 days, add a new column and update the rows as Yes. else keep it blank.

[grazitti_sapna]

Hi @Lakshmikanth_2021, try this.

if DateTimeDiff(DateTimeToday(),[Created On],'days')>=0 and
DateTimeDiff(DateTimeToday(),[Created On],'days')<=7 then "Yes" else Null() endif

I hope this helps!

Thanks!

[binu_acs · Accepted solution]

@Lakshmikanth_2021 similar to @grazitti_sapna solution

IIF(DateTimeDiff(DateTimeToday(),[Created On],'days') <= 7 AND DateTimeDiff(DateTimeToday(),[Created On],'days') >= 0, 'Yes', Null())