blank date to date field in table (1 Viewer)

[Gr3g0ry]

how can i specify a blank date for a field in my table. the field in my table is a date field.

it is called end date and its supposed to be blank or null till i decide to update it. any suggestions ??

 

[CJ_London]

unless you give it a default value, it will be null.

So what is the actual problem?

 

[Gr3g0ry]

i wanted to have a default value for my EndDate, like 00/00/0000.

When i declare my variable as date and not assign a value, i get 12:00:00 am as my default value.

thats ok but i wanted to use it as a placeholder in a disabled text box.

is there a way i can get 00/00/0000 to use

 

[arnelgp]

Is it a single form.?

 

[Pat Hartman]

Date fields are NOT strings, they are double precision numbers. The integer part is the number of days since Dec 30, 1899 (Jet/ACE - SQL Server and Excel use different origin dates but the same concept) and the decimal is the time since midnight. Negative numbers are prior to Dec 30, 1899 That makes Dec 30, 1899 = 0.0.

So, there is no way you can store 00/00/0000. Just leave the field null. This isn't 1980's COBOL.