Query for 1st day of month after 60 days

  • Thread starter Thread starter Donna Brooks
  • Start date Start date
D

Donna Brooks

Hi,
I have a field HireDate and an expression InsEffDate. I
need the InsEffDate to display the first day of the next
month after 60 days. Can someone please help me?

Thanks,
Donna Brooks
 
Donna,

Try it like this...
InsEffDate: DateSerial(Year([HireDate]+60),Month([HireDate]+60)+1,1)
 
Back
Top