[prodsupptech]

I copied my friends post from another forum. Below is his request. Please let me know if anyone can help.

First off, Im using Access 2000, and created a new module.

Ok, Here is the info:

-A table called Indexing contains a field Index9
-Index9 needs to be updated to the current date, in a particular format.
-the format is as follows: YYYY-MM-DD

I would Like to create a module to do this, but im not sure how i would make this run or work, meaning do i make a function? how do i get it to run? using a macro? etc etc...

But first off, how do i update Index9 with the date in the particular format?

Here is the code i could come up with:

Sub Format()

Dim strSQL As String

Dim currentdate As Date
Date = Now 'Format(Now, "yyyy-mm-dd") how do i format this?


strSQL = "UPDATE Indexing, SET [Index9] = Date, WHERE [Index9] Is Null;"

DoCmd.RunSQL strSQL

End Sub

[Rockn]

Are you updating the field from a form or just from the query? Date is a reserved word so use something else.

[Rockn]

strDate = Format(Now(),"yyyy-mm-dd")

[prodsupptech]

Originally he was making a program in VB to do this. We both realized that it was had probably been the long way. Your help worked very well and we both thank you.

Thanks Again