Date Format

[softpro]

Can I specify a column to store only the date value,

is there any formatting option, so I can say like
col1 datetime format ('mm/dd/yyyy')


Can I specify Validation rule and text in SQL Server like in Access.
So that way I can keep all the validation texts stored right in DB not in Form level.
How to specify the validation text in SQL Server constraint?

Thanks a lot for all your help.

 

[bradcccs]

Can I specify a column to store only the date value

Access actually stores dates as a number (simple explanation).

You can display the date in whichever format you wish.

When you say "only the date value" are you referring to the fact that you currently get date and time?

If so, it is likely that you are using the Now() operand and should be using Date()

Brad.