Help
Claremont_Scout
4 - Data Explorer
4 - Data Explorer
since ‎Jul 08, 2019
‎Nov 29, 2022

User Statistics

  • 5 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

I am trying to calculate the number of months to an 18th birthday. I start with the Date of Birth and add 18 years to that. I format that date so that I get DD/MM/YYYY and not the American MM/DD/YYYY. That works fine. Now I use the following formula ...
Is there a way to use hard coded dates in a date calculation e.g. Date Diff(1/1/2019,Today()). I can get the right calculation if both dates are in fields but the moment put in a hard coded date it doesn’t work. Any ideas?