Skip to main content

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! 🙂


Dan

Either:


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

or


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

Either:


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

or


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


Perfect!!! Thank you very much!


Reply