DateTime Formula calculation

[Shree185]

I am trying to count weekly tickets created Mon - Sunday without adding a week filter. Scheduled Alteryx workflow runs every Sunday night to get every week's count in an append manner

I need a calculational help

count of "CreatedDate" field between  CreatedDate = Today AND Date of (CreatedDate = Today) - 7

Example = Monday 10/28 and Sunday 11/03, workflow is running on Sunday night.

[Yoshiro_Fujimori · Accepted solution]

@Shree185 ,

You may want to add a Formula Tool to add a field "inRange" (Int)  as 

[inRange] = 

IF [CreatedDate] > DateTimeAdd(DateTimeToday(), -7, "day")
AND [CreatedDate] <= DateTimeToday()
THEN 1
ELSE 0
ENDIF

... followed by Summarize Tool to get the record count in Range.

Hope this helps.