How can we check empty DateTime fields.

51 views
Skip to first unread message

M. Asif Hussain

unread,
Oct 3, 2021, 10:50:32 PM10/3/21
to mementodatabase

 How can we check in a Calculation field script if another DateTime field is empty? To avoid undefined calculation results.

I have tried something like this:

if(     length(#{datetime of arrival})==0,           ,datediff(now(), #{datetime of arrival})    )

Er Mo

unread,
Oct 4, 2021, 1:28:20 PM10/4/21
to mementodatabase
Hallo
Wenn ein Feld Leer ist gibt es den Wert " null "( Diese 4 Buchstaben )  zurück .

Hello
If a field is empty it returns the value "null" (these 4 letters).
Reply all
Reply to author
Forward
0 new messages