Search results
-
S
Query Date Parameter Month
This worked perfectly! Thank you so much!- SP_Brandon
- Post #5
- Forum: Queries
-
S
Query Date Parameter Month
Hi Friends! I need some assistance with date parameters in a query! A Google search returned using Month(Date()). I also tried Month(Now()) and Month(Today)). None of these worked. Then, I found a website that provided the following formula: Between DateSerial(Year(Date()),Month(Date())-1,1) And...- SP_Brandon
- Thread
- Replies: 5
- Forum: Queries
-
S
ExportWithFormatting with current date in file name
Hi! Thanks for the welcome! Yes, I noticed it's quite old indeed! :) & "_" & Format(Date(),"yyyymmdd") & ".xlsx" is not working for me! I tried using DoCmd.OutputTo and DoCmd.TransferSpreadsheet--both of which gave me error messages. Please see below: DoCmd.OutputTo Folder Path and Filename...- SP_Brandon
- Post #5
- Forum: Macros
-
S
ExportWithFormatting with current date in file name
& "_" & Format(Date(),"yyyymmdd") & ".xlsx" is not working for me! I tried using DoCmd.OutputTo and DoCmd.TransferSpreadsheet--both of which gave me error messages. Please see below: DoCmd.OutputTo Folder Path and Filename: DoCmd.OutputTo acOutputQuery, "Missing Info", acFormatXLSX...- SP_Brandon
- Post #3
- Forum: Macros