Why doesn't date calc correctly in edit form?

Help Center Get Answers
1

Have a DateOfBirth field, and also an Age field. Used the recommended formula in an equation field to calculate age. The age calculates perfectly when displayed in a table view (including for DOB < 1970). But in an edit form page, it’s very wrong. Displays a very long number. I assume it’s seconds.

What’s up with this? Have something to do with this being displayed on an edit form? It’s not a huge deal (I can leave the age calc off this form) but I’m curious to know what’s going on here.

image

2

@WilliamPorter - without digging into it, I’d agree that it seems to be showing seconds.
Personally I rarely show calculated fields on an edit page as it will update once the user has amended the record.

3

Thanks for weighing in. I decided to remove it.

1 Like