30 Days or Less

[Nick CWT]

I have a date field = Job Readiness Assessment CG 1 and a date field = Date
Enrolled. I'm trying to create an expression in a report that indicates the
% of Job Readiness Assessments that were completed in 30 days or less from
date enrolled. I'm stuck

 

[Duane Hookom]

In your report or group header or footer, you can use an expression like:
=Sum(Abs(DateDiff("d",[Date1],[Date2]) <=30))/Count(*)

 

[Nick CWT]

Thanks for your reply. As you suggested I'm using

=Sum(Abs(DateDiff("d",[Job Readiness Assessment CG 1],[Date
Enrolled])<=30))/Count(*)

in the footer of the report. But it seems to be counting all dates fields
that are not empty? It doesn't seem to be applying the <=30? Date enrolled
will never be Null but the CG's may be. Does that matter? I appreciate any
and all help.

In your report or group header or footer, you can use an expression like:
=Sum(Abs(DateDiff("d",[Date1],[Date2]) <=30))/Count(*)

--
Duane Hookom
Microsoft Access MVP

I have a date field = Job Readiness Assessment CG 1 and a date field = Date
Enrolled. I'm trying to create an expression in a report that indicates the
% of Job Readiness Assessments that were completed in 30 days or less from
date enrolled. I'm stuck

 

[Duane Hookom]

Inside the DateDiff() function, the earliest date should be first.

How do you want to count/handle null dates? You can use Nz([...cg...], [Date
Enrolled]) or Nz([...cg...], [Date Enrolled] + 100)
--
Duane Hookom
Microsoft Access MVP

Thanks for your reply. As you suggested I'm using

=Sum(Abs(DateDiff("d",[Job Readiness Assessment CG 1],[Date
Enrolled])<=30))/Count(*)

in the footer of the report. But it seems to be counting all dates fields
that are not empty? It doesn't seem to be applying the <=30? Date enrolled
will never be Null but the CG's may be. Does that matter? I appreciate any
and all help.

In your report or group header or footer, you can use an expression like:
=Sum(Abs(DateDiff("d",[Date1],[Date2]) <=30))/Count(*)

--
Duane Hookom
Microsoft Access MVP

I have a date field = Job Readiness Assessment CG 1 and a date field = Date
Enrolled. I'm trying to create an expression in a report that indicates the
% of Job Readiness Assessments that were completed in 30 days or less from
date enrolled. I'm stuck

 

[Nick CWT]

I did not have the earlier date first, that fixed it. You're an MVP in my
book. Thanks a bunch!!

Inside the DateDiff() function, the earliest date should be first.

How do you want to count/handle null dates? You can use Nz([...cg...], [Date
Enrolled]) or Nz([...cg...], [Date Enrolled] + 100)
--
Duane Hookom
Microsoft Access MVP

Thanks for your reply. As you suggested I'm using

=Sum(Abs(DateDiff("d",[Job Readiness Assessment CG 1],[Date
Enrolled])<=30))/Count(*)

in the footer of the report. But it seems to be counting all dates fields
that are not empty? It doesn't seem to be applying the <=30? Date enrolled
will never be Null but the CG's may be. Does that matter? I appreciate any
and all help.

In your report or group header or footer, you can use an expression like:
=Sum(Abs(DateDiff("d",[Date1],[Date2]) <=30))/Count(*)

--
Duane Hookom
Microsoft Access MVP


:

I have a date field = Job Readiness Assessment CG 1 and a date field = Date
Enrolled. I'm trying to create an expression in a report that indicates the
% of Job Readiness Assessments that were completed in 30 days or less from
date enrolled. I'm stuck