Hi there,
This is a common question that I wish it does not have to involve a formula. But I guess it should.
Can you tell me the way to write a formula to specify how I can account the total number of active projects for one month (Feb 2025)? I have a start date and end date.
Combo Request Date
Needed By Date
Date format MM/DD/YYYY
When I write the formula it is not capturing the correct records active in Feb 2025.
IF(
AND(
OR(
DATETIME_FORMAT({Combo Request Date}, 'MM-DD-YYYY') >= '02-01-2025',
AND(
{Combo Request Date} <= '02-28-2025',
{Needed By} >= '02-01-2025'
)
),
{Needed By} >= '02-01-2025'
),
1,
0
)
Do I need to specify status on-going, complete, in progress?
