Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Compare two date fields for report generation

IceIronDragon
Tera Guru

Hello All,

 

We have a requirement to Generate a report based on 2 Date fields.

We need to know How many records have Same date on both fields.

Field1: " Actual Date"

Field2:"Projected Date"

We need to see how many records have same value for both fields and generate a report.

 

Thank you

1 REPLY 1

SatyakiBose
Mega Sage

Hello @IceIronDragon 

Your report should be configured as below:

SatyakiBose_0-1678269557297.png