Form - Field Formula - Set a date to NULL

In a form, how do I set a formula field date to null?

It does not work....

If(Not(Contains(Trial_Period, 'NA')), AddDate(Dateofjoining, ToNumber(SubString(Trial_Period,1,1)), 'Month'), null)

Field - 'null' does not exist in this form

If(Not(Contains(Trial_Period, 'NA')), AddDate(Dateofjoining, ToNumber(SubString(Trial_Period,1,1)), 'Month'), 'NA')

The second and third operands of built-in function 'If()' should be of same type.

So I need to set the third operand to a date type (NULL?)

I Tried:

If(Not(Contains(Trial_Period, 'NA')), AddDate(Dateofjoining, ToNumber(SubString(Trial_Period,1,1)), 'Month'), GetDate(NewDateTime(0,0,0,0,0,0)))

Result:

Trial Period = NA

It returns --> End of Trial Period 30-Nov-0002 (???)

Any idea?

Thanks

Sticky Posts
Meet the Zoho People experts in your city!
Dear users, We are delighted to invite you to the Zoho People's user community meetup. We are stoked to visit our users in their cities and help them with all things Zoho People. Join us for a day of insightful Zoho sessions, interactions with other

Topic Participants