Still Dating

Sep 19, 2006

Select * from myTable where datein = Convert(datetime,'19/09/2006')

In myTable I have Data that are Today and thequery above does not get it
why

If it is that easy, everybody will be doing it

View 4 Replies

History Using Effective Dating

Apr 4, 2006

I did a search of the forums and couldn't find any other threads on "Effective Dating" so please forgive me if this topic has already been covered.

Does anyone know of any support articles or tutorials covering the topic of "Effective dating" as a means for keeping a history for data?

I would like to keep a infinite history on certain tables and would like to avoid duplicating data structures if possible. Any suggestions?

Thanks,

JAndrews

View 4 Replies View Related

Tracking History Using Effective Dating

Apr 4, 2006

Can anyone provide me with some insight on tracking the history of my data using "Effective Dating"? I would like to keep track of an infinite history for many of the tables in my database and am trying to avoid duplicating data structures if possible.
Any advice on this topic would be appreciated, I am most interested in any links to tutorials or support articles on subject that you may know about. I have searched the web and the forums section and have not come across much.
Thanks,
JAndrews

View 4 Replies View Related