Assigning Blank Date

  • Thread starter Thread starter Sunny
  • Start date Start date
Can I assign blank date (not NULL) to date field, if yes how?

No. A Date/Time value is a Double Float number, a count of days and
fractions of a day since midnight December 30, 1899. It can contain a
number (corresponding to a date between January 1 100AD and 11:59:59pm
December 31, 9999; or it can be NULL. But that's the only options.

What's wrong with NULL? it displays as blank!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top