INSERT INTO with Date Format MMMM YYYY (1 Viewer)

[Malcolm17]

Hey All,

I'm trying to use an insert into statement to log an action in my system, I am looking to show the record with Printed on MMMM YYYY, however the date format is the issue at the end (I always seem to have an issue with date format, I just cannot get it.

Please can you tell me what my statement would need to be to do this, I'm using:

DoCmd.RunSQL "INSERT INTO tbl_Net_UserLog (Computer, UserName, SystemDate, Action) SELECT Forms.frmBackground.txtComputer & ' (' & Forms.frmBackground.txtComputerUser  & ')', Forms.frmBackground.txtUserName, Forms.frmBackground.txtLocalSystemDate, 'Printed ' & forms!frmbackground!subfrmBuyingList!cboBuyingList & ' Buying List for ' & Format(forms!frmbackground!subfrmBuyingList!cboBuyingListDate, "\#mmmm yyyy\#")"

the problem is with:

Format(forms!frmbackground!subfrmBuyingList!cboBuyingListDate, "\#mmmm yyyy\#")

Thank you

 

[cheekybuddha]

Dates are dates - they are stored without format.

SQL requires an unambiguous date format when referring to dates. Either yyyy-mm-dd or mm/dd/yyyy

Use:

Format(forms!frmbackground!subfrmBuyingList!cboBuyingListDate, "\#yyyy\-mm\-dd\#")

Then, format it in the SELECT portion when you need to display the date.