Microsoft Dynamics 365 | Integration, Dataverse...

Calculated field based on date

(0) Share

Report

Posted on by RyeTeacher

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?

All responses (2)

Answers (0)

RyeTeacher 163 on at

Like (0)

Report

RE: Calculated field based on date

There is no way to convert a date? It seems weird to have a custom field with the same date for every record.
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: Calculated field based on date

Hi,

You could create new custom field of type date to store the first day of school and use that in your calculated field.