Script for Count of Records using Multiple if between dates

gandekoutilya — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Script for Count of Records using Multiple if between dates

vishsaggi — Thu, 20 Sep 2018 19:46:19 GMT

May be this?

Load

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

From Resident TableName;