Convert Date to String

[Sandy Radjenovic]

Via VBA, I am cutting and pasting a row from the current worksheet to a "done" worksheet which lists all jobs done. This "DONE" worksheet is eventually exported to a dbf.

I would like to update a cell in the "done" worksheet to be that of today's date to reflect date of transfer. Unfortunately, the column I have to work with is a formatted text column. Is there a way to convert a date (i.e. now() ) to a string?

Your help would be appreciated!

 

[Joe4]

See the FORMAT text function in VBA. It works very much like the TEXT Excel function.

i.e.
MYSTRING=FORMAT(NOW(),"yyyymmdd")

 

[Sandy Radjenovic]

Works Perfect ... Thanks!