Assign 'null' to date column6 followers
hopefully it's an easy question but I haven't managed to find the answer to it in the documentation nor the community forums.
I need to make a union of two slightly different worksheets. One is of type date and I want to set it to null so that the resulting union only has values that have meaning.
I've tried NULL, Null, null and none of them seem to be working. All I need is a column of format date with nulls/empty/blank as values for each row.