Null value for Date Variable

[fless1]

setting  varDate=datepicker.selecteddate but want to set varDate to be blank if a tick box "No date required" is selected

but set(varDate,"") comes up with "imcompatible type" error

[Drrickryp · Accepted solution]

Hi @fless1,

check this out https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-C...

it may be the answer you are looking for. If it works, please mark this thread as solved.

[fless1]

Thanks loads

[cbrazenec]

Instead of "", use Date(Blank(),Blank(),Blank()).  Sets it to null value, but in a date format.

[takolota]

None of these answers worked for me and I really did not want to recreate the date columns in separate text columns.

I had to use this formula on the submit button:

SubmitForm(Form1); If(Or(IsBlankOrError(DataCardValue8.SelectedDate), IsBlankOrError(DataCardValue9.SelectedDate)), RecordsRetentionSetNullDates.Run(RecordsRetentionList.Selected.ID, IsBlank(DataCardValue8.SelectedDate), IsBlank(DataCardValue9.SelectedDate)), "");

And set up a corresponding flow to input those null values in the date fields.