163
I need to create a calculated field based on a date. I am working with a school database and I was able to create a calculated field to figure out their age. But I need to create another calculated field to identify their date at the start of the school year. This is the age calculation
DiffInYears(asa_studentdob, Now()).
What I want to do is replace the Now() with the first day of school. If I add a date it gives me an error. Is there a way to do this?
There is no way to convert a date? It seems weird to have a custom field with the same date for every record.
Hi,
You could create new custom field of type date to store the first day of school and use that in your calculated field.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (