Now() uses date AND time

[camidon]

I'm using an SQL UPDATE string that is supposed to set one of my fields to the current date. The only problem is when I use "IssueDate = Now()" it appends both the date and the time into the field.

What is the proper syntax of Now() that will allow me to set the format to just put a short date in the field?

 

[Guest_imported]

date()

 

[camidon]

Will it give a short date in the form of mm/dd/yyyy???

 

[THoey]

I would use the DATE() function and I would also make sure that you format the field to hold values as a short date.

Hope that helps...

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?