GETDATE()

[dmaier]

I just tried to use the GETDATE()function in design view for a table column. It is a smalldatetime data type and the length is supposed to be 4. Every time I save the record it saves as this (getdate()) and it doesn't work when adding a record.

Does anyone know what the problem might be?

 

[JayKusch]

Are you using the GetDate() function in the default setting area?

Thanks

J. Kusch

 

[dmaier]

No it is in the Table Design view in Default Value.

 

[Veep]

Are there single quotes around it?

 

[JayKusch]

That is what I meant. Hmmm interesting! You are not supply a value for that field when you are inserting ... are you?

Thanks

J. Kusch

 

[jhall156]

The Default Value for a column must be a constant expression. You could maintain it with an insert trigger but whatever process is inserting a record would be the place to put code to insert the current date IMHO.

JHall

 

[dmhirsch]

jhall - I just tested (getdate()) as a default in EM for a datetime field with no problems.

 

[jhall156]

My bust, you're right. I just had it work for me too. My apologies.

JHall