RascalBird
Registered User.
- Local time
- Today, 12:29
- Joined
- Oct 5, 2004
- Messages
- 20
Hi there
I hope you can help me out, I've been going crazy trying to work out this problem.
I'm using Access 2010 and have a SQL INSERT INTO statement to automatically create a new record in a table.
I have another form where I have successfully forced the date to be inserted in the "dd/mm/yyyy" format and everything is perfect. For some reason this time it is not working.
I have tried to use
on this occasion and am beating my head against a brick wall.:banghead:
I have checked regional settings, ensured field format settings are off and still no luck.
Any thoughts as to what I'm missing?? Below are 3 of the lines of code relating to one of the date fields.
Thanks in advance
I hope you can help me out, I've been going crazy trying to work out this problem.
I'm using Access 2010 and have a SQL INSERT INTO statement to automatically create a new record in a table.
I have another form where I have successfully forced the date to be inserted in the "dd/mm/yyyy" format and everything is perfect. For some reason this time it is not working.
I have tried to use
Code:
paydue = format(date,"dd/mm/yyyy")
I have checked regional settings, ensured field format settings are off and still no luck.
Any thoughts as to what I'm missing?? Below are 3 of the lines of code relating to one of the date fields.
Code:
dim paydue as date
paydue = Format(Date, "dd/mm/yyyy")
paydue = DateAdd("m", 3, Me.BASPaymentDueDate.Value)
Thanks in advance