Date (1 Viewer)

[Thedon123]

i am creating a text file using vb of arecrd in a databse.

when the user saves a file it automatically suuggests the file name i have set.

So it woul
d automatically suggest the file is saved as. latest.txt.

What i need help with is i would like to know if there is a way in vb to put the date in the filename automatically so it would save the file as latest(currentdate). e.g latest131102.txt

thanks for your help.

 

[simongallop]

Presume that you have something like

FileName = "latest.txt"

Instead have:

MyDate = Format(Now,"ddmmyy") 'Or whatever format you want!

FileName = "latest" & MyDate & ".txt"

This will give you latest131102.txt

HTH

 

[Thedon123]

thank you very much. it worked.