Hello- I’ve used this method before and it’s worked fine, but I can’t get it to work on another form.
Setup:
– Existing form that has the Date Created field (automatically populated when a record is created)
– I added a calculation field with the following formula: ($now –
[date created field]) / 86400
Problem: This formula is generating a 0
I also tried /60/60/24 (instead of 86400). Still produces a 0.
Is this because I added after field after the record was already created?
Any tips to get it to calculate?
Thx!
The problem is with the Date Created field. It’s sort of a special case field because it draws its value from the record itself rather than the list of values associated with the record. I just looked at the calculation code and it seems that I’m not taking into consideration the Date Created or Date Modified fields when performing calculations. That’s something I’ll have to add support for. You’ll need to use a regular Date & Time field instead of the Date Created field at the moment. Sorry about that.
Thanks,
Brendan
Got it. At least I know its not something I’ve done in error. Thx for the info. I’ll just create a new field.
.
