BCS Select Distinct Date From DateTime

There are those occasions when the distinct date needs to be displayed from date time values. Considerable coding and displaying results via a list box control is one way to accomplish this feat.
On the other hand you could let SQL handle the gory details. In an ADO situation the following statement handles the request quite nicely.
select distinct CAST(datafieldname as date) from databasetable
The result set will contain distinct dates for the target table.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems authored this article.

Leave a Reply

Your email address will not be published. Required fields are marked *