Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
Load
Count(If([Current Status] = 'Filled' AND [Requisition Filled Date] >= MakeDate(2018,8,1), [Aged Requisitions])) as [Filled]
From Resident TableName;