S
Simon Harris
Hi All,
I am storing a date value in a table. THe table column data type is set to
short date. My SQL to do the update takes the value from the form, using
CDate(Me.comboInvoiceDate).
When I look at the value in the table, it looks Ok - 11/01/2007. But, when I
view my report, which shows the Month and year for that value, it come out
as November 2007, not January 2007 as expected. I realise why - I have an
ambiguious date, but how do I tell Access the date format to use. I would
like it to use UK format - DD/MM/YYYY
This is my code on my report: CDate(Me.comboInvoiceDate)
Any help will be much appreciated.
Regards,
Simon.
--
--
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
I am storing a date value in a table. THe table column data type is set to
short date. My SQL to do the update takes the value from the form, using
CDate(Me.comboInvoiceDate).
When I look at the value in the table, it looks Ok - 11/01/2007. But, when I
view my report, which shows the Month and year for that value, it come out
as November 2007, not January 2007 as expected. I realise why - I have an
ambiguious date, but how do I tell Access the date format to use. I would
like it to use UK format - DD/MM/YYYY
This is my code on my report: CDate(Me.comboInvoiceDate)
Any help will be much appreciated.
Regards,
Simon.
--
--
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!