Date/Time in save as file name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick X - 17 Jan 2006 20:55 GMT

Hi all,

I am sending a query out to a spreadsheet format:

DoCmd.TransferSpreadsheet yadda, yadda, yadda, conPath & "yadda yadda" & " -
Saved_" & Format(Date, "mm-dd-yyyy") & ".xls", True

I would like this portion to show the date AND time:
Format(Date, "mm-dd-yyyy")

Unfortunately, Windows will not allow a file to be saved with the ":"
(colon) character. Can anyone see a way around this? I tried using "."
(period) but that returned 0.00.00

Thank you in advance,
Nick X

Reply to this Message

Ofer - 17 Jan 2006 22:20 GMT

You should use Now() instead of Date() that doesn't return the time.
I would save it in this format

Format(Now(), "yyyymmddhhmm")

It make it easier to sort the file by name in this format

Signature

\\// Live Long and Prosper \\//
BS"D

> Hi all,
>
[quoted text clipped - 12 lines]
> Thank you in advance,
> Nick X

Reply to this Message

Nick X - 18 Jan 2006 13:19 GMT

Thank you, that'll work.

> You should use Now() instead of Date() that doesn't return the time.
> I would save it in this format
[quoted text clipped - 19 lines]
> > Thank you in advance,
> > Nick X

Reply to this Message