Back to all

Today's Date in Formula Field

Hi guys, does anyone know if it is possible to get today's date into a formula field. My client wants a dashboard to be set up that will allow them to see what opportunities have a close date 1 month from now, 2 months from now and 3 months from now. Unfortunately the Duration field does not work, but if I can get todays date into a formula field I can work out how many months the close date is away and get this to work for them.

Please let me know if this is possible?