Dear,
I can set a datefield to the current datetime with:
Patch(MyTable, LookUp(MyTable, MyTableID=ThisItem.ID), {MyDateField: Now()})
But now I also want to be able to clear that field...
I have tried:
Patch(MyTable, LookUp(MyTable, MyTableID=ThisItem.ID), {MyDateField: Date(Blank(),Blank(),Blank())})
Patch(MyTable, LookUp(MyTable, MyTableID=ThisItem.ID), {MyDateField: Blank()})
But that doesn't work (it is executed without errors, but the date field of the record is not cleared)?