Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gandekoutilya
Contributor
Contributor

Script for Count of Records using Multiple if between dates

I'm Beginner and need some help in writing a script for count of Records using Multiple if Between dates

This is what i came up with

Load

TextCount(If([Current Status] = 'Filled', [Requisition Filled Date] >= MakeDate(18,8,1), [Aged Requisitions])) as [Filled]

The Script executes successfully, But i can't see anything on the Graph

Please Someone can advise on this

1 Reply
vishsaggi
Champion III
Champion III

May be this?

Load

          Count(If([Current Status] = 'Filled' AND [Requisition Filled Date] >= MakeDate(2018,8,1), [Aged Requisitions])) as [Filled]

From Resident TableName;