2 Replies - 4735 Views - Last Post: 06 April 2012 - 03:23 PM

#1 amre  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 06-March 12

running a query with date() not showing the data

Posted 05 April 2012 - 03:51 PM

I have a strange issue with a query in an access 2003 database that I am running.
The query should list data from sales that were made today from date() in the criteria.
I used the database yesterday(04/04/2012) and it worked ok, although nothing has been changed
it is now not showing todays sales(05/04/2012).

I changed the date on my computer to (04/04/2012) and the query works fine.
So I tried changing the date on my computer to various dates, the query worked on
some dates but not others.

I am not changing anything on the query or any part of the database.

Has anyone any ideas on the reason for this, and if there is a solution??

Is This A Good Question/Topic? 0
  • +

Replies To: running a query with date() not showing the data

#2 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: running a query with date() not showing the data

Posted 06 April 2012 - 12:56 PM

Only cause I can think of is international date formats. Review http://allenbrowne.com/ser-36.html
Was This Post Helpful? 0
  • +
  • -

#3 amre  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 06-March 12

Re: running a query with date() not showing the data

Posted 06 April 2012 - 03:23 PM

Yeah i thought it must be something to do with that, and i had already checked the database date formats.
after reading your post I realised that i forgot to check the Visual basic bit..... it was formatted wrongly. I feel a bit stupid now for never noticing this before.
Thanks for your help anyway.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1