Skip to main content

Difference in Dates to Weeks

  • July 20, 2022
  • 2 replies
  • 19 views

Forum|alt.badge.img+7

Good Morning,

I am trying to create a “Weeks Active” field in a base. I have a “schd_start” date field and a calculated “Today’s Date” field. I would like to determine the difference between the two dates and have Weeks Active then calculated. Thank you in advance! :slightly_smiling_face:

Dan

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

Either:

DATETIME_DIFF({schd_start}, {Today}, "weeks")

or

DATETIME_DIFF({Today}, {schd_start}, "weeks")

Forum|alt.badge.img+7
  • Author
  • Inspiring
  • 16 replies
  • July 20, 2022

Either:

DATETIME_DIFF({schd_start}, {Today}, "weeks")

or

DATETIME_DIFF({Today}, {schd_start}, "weeks")

Perfect!!! Thank you very much!