date amd text as same column

[drunkenneo]

I have a form displaying table in data sheet view, in which i have date recieved column in which user input the feed when recieved.

My situation is this have to be blank or date ddmmyyyy or cancelled. How can i achoeve this is single column. As i have to calculate the on the basis 10 working days from today. Please help

[ItsMe]

Maybe an input mask at the form level for your format. Data type at the table level would be "text" data type. When you need to do the math, you can assign the literal text in your table to a Variable of the Date data type. Use the declared variables for your calculations at the time needed. Otherwise, the values are always of the text data type.