Is it possible for a date calculation field to return a null value?
Iâm trying to calculate the âLast Contactedâ date, but if the lead hasnât been contacted yet, I want the field to remain empty so I can use the âHidden if emptyâ option. Instead, itâs showing âThursday, January 1, 1970 ¡ 1:00 AMâ by default.
Can you provide more details?
From what I can guess, you have one Date field and one calculation field (both with âHidden if emptyâ option).
I tried adding those two fields and referencing the date field in the calculation. It does not give me Thursday, January 1, 1970 ¡ 1:00 AM when the date field is empty.
Are you using an âall ofâ date field, and is the field set to date format rather than text?
Itâs pulling from a date field in another app, so maybe Iâm overlooking something simple.
Basically, I have a date field in the Communications app, and Iâm trying to get the âLast Contacted Dateâ so I loop through the âCreated Onâ dates and the âCommunication Typeâ fields to check if the communication type was outgoing. The calculation works fine when thereâs a date, but it returns the 1970 default when thereâs no communication.
Iâm trying to replicate what you mentioned, but I donât think Iâm doing it as you have it.
Do you have access to the Tape Partners workspace? See here. I can send you an invitation to join.
If you make a copy of your workspace (with dummy data) there, I or other Tape Partners in that workspace can examine your setup and try to find a solution.