Storing a default datetime field in SQL Server 2000

[SonJ]

Hi,

I have to store a datecreated field in one of my databse tables (SQL Server 2000) and am unsure how to give it the default value of what would be Now() in VBScript. I have tried Now() and upon saving the table, it throws it out as an unrecognised function. I know that it is possible to do, as I have done it before, but cannot remember how to do it.

Any pointers/ help would be much appreciated.

Thanks in advance,

SoniaD

 

[SonJ]

Its ok, I have found out how to do it. I needed to use the SQL function of GetDate() rather than the VBScript function of Now()