Date is Null

[Francisco1988]

I have this script in the request date column. But if the fill is blank, the message:" this entry is invalid" How to solve this? IF([Status da Solicitacao] = Entregue, TODAY(), "null")I need the form to accept a null date if this is the condition... 

[Suvrutt_Gurjar]

Please try

IF([Status da Solicitacao] = "Entregue", TODAY(), "")

[Francisco1988]

 I tried this way it didn't work...

[Suvrutt_Gurjar]

Could you elaborate what you mean by " it didn't work..."

It should work. However please note that a blank value will not show in detail view. So if a date is blank , it will not show in the detail view.

Below are test results

[Francisco1988]

 

[Suvrutt_Gurjar]

Please post the screenshot of the column settings where you are using this expression.

If you want it in a user editable column, please have the expression in the initial value of the column.

[Francisco1988]

 

[Francisco1988]

 

[Suvrutt_Gurjar]

I had actually requested for other settings of the date column as well. Anyway, please do not mark the column as "Required" because you wish to have blank value in the column. Required" setting needs some date value to be present in the column. That is why you are getting that error.

[Francisco1988]

but the required column is disabled...

[Suvrutt_Gurjar]

As requested, please post all the settings of the date column.

[Francisco1988]

After a few attempts I managed to follow your request IF([Request Status] = "Delivered", TODAY(), "").
The problem now, when I save the form without typing the date, when I return to the same form and mark the request status field as "In Progress" the "start date" field is not automatically filled in with the date of the day...

[Suvrutt_Gurjar]

Please enable reset on edit in that column.

[Francisco1988]

How do I do this reset activation?

[Francisco1988 · Accepted solution]

conditions

Initial Value formula for column Data Inicio (Date)
IF([Status da Solicitacao] = Em Andamento, TODAY(), "")

Initial Value formula for column Data Termino (Date)
IF([Status da Solicitacao] = Entregue, TODAY(), "")

Could you help me to better these two conditions? After activation, a value is deleted according to the selection of the field "request status"