Solved Create a numeric date from a query (1 Viewer)

[access2010]

Could I please receive a suggestion on how to change our exported date from a Text Name to a Numeric name using Ms Access 2003?

The current exported file's name is => Yahoo_Equity_2022_October12.Csv

We would like the new file name to be => Yahoo_Equity_2022_10_12.Csv.csv

The ne file name's extension is => .Csv.csv

Your suggestion will be appreciated.

Nicole

 

[plog]

Remove the MonthName function.

 

[access2010]

Thank you Plog for your suggestion.

NM = "Yahoo_Equity_" & Year(Now) & "_" & (Month(Date)) & Day(Now)
, the changed file results, are now => Yahoo_Equity_2022_1013

' NM = "Yahoo_Equity_" & Year(Now) & "_" & MonthName(Month(Date)) & Day(Now)
' previous file name was => Yahoo_Equity_2022_October13

Can you please advise us how we can have an underscore placed into the file name as => Yahoo_Equity_2022_10_13

Nicole

 

[plog]

How'd you get one between the year and the month?

 

[CJ_London]

I would use

NM = "Yahoo_Equity_" & format(Date(),"yyyy_mm_dd") & ".Csv.csv"

Although in windows explorer you could just tick the File Nmae Extensions box on the view tab to show file extensions so you don't need the .Csv

 

[access2010]

Thank you CJ_London.

Your suggestion is P.E.R.F.E.C.T. for a special web program that we are using.

Nicole