Include time in format(YYMMDD)

[charly.csh]

Hi everyone,

I am creating a report with a consecutive name and also want to include the time like HHMMSS but it doesn't work and just shows the format as 000000
What Do I change to my code on this part?

Private Sub ExportarPdfcmd_Click()

Dim stDocName As String
Dim stFileName As String

stDocName = "Report_Rpt"
stFileName = "Report of Open Actions "

'What should be changed on my format?
DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, stFileName & Format(Date, "YYYYMMDD-HHMMSS") & " - " & Me.UserNamelbl.Caption, True
MsgBox "Report", vbInformation, "Testing"

End Sub

Thanks for the help!!

[Gicu]

You need to use the Now() function to return time, Date() does not have a time component.
Cheers,

[Bob Fitz]

Try:
Format(Date, "YYYYMMDD") & "-" & Format(time,"HHMMSS")

[charly.csh]

Great both solutions!!!
Many thanks!!!