[thelist] Date Masking in SQL Server 2k?

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Subject: [thelist] Date Masking in SQL Server 2k?


: Anyone had experience in date masking, as the term is used in Access, in
SQL
: Server 2k? If so, how? I've Googled and only found headaches.
:
: Thanks,
: Rob Smith

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I assume you're talking about restricting the format in which a user can
input data?

If so, this is best handled in the presentation layer (which Access is).
Dates, in a database, are typically stored as numbers, and so any valid
string representation that can be intepreted as a date, and converted to the
appropriate numeric value, is acceptable. If you have a business rule that
restricts the format of the date, then you do this at the presentation layer
(Access, VB, ASP pages).

Otherwise, can you give us more details on what you're trying to accomplish,
and we might be able to suggest alternatives.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)