Date Format......Again!!! Sorry

[louchey]

Hi Guys,

Know this must of been covered before, but had trouble finding a solution inthe archives. I'm working in Australia at the moment and would like to change the date format.
I have created a module that exports data to an excel file, and gives the file name todays date. I would like to change the format from MM/DD/YYYY to DD/MM/YYYY. As I said I'm sure this is an easy one.
Any help much be greatly appreciated.

Louchey

Public Function exportFile()
Dim FileToExport As String

FileToExport = "S:\SHARED\John Brussen\Pipe_Supports_" & Date$

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Pipe_Supports", FileToExport
End Function

 

[Travis]

FileToExport = "S:\SHARED\John Brussen\Pipe_Supports_" & Format(Date$,"DD/MM/YYYY")

 

[louchey]

Thanks very much Travis - Simple when you know how eh!!!

Louchey