date() problem 1

[Guest_imported]

I'm filtering a recordset using the date() expression such that only records with todays date are shown on a web page. However date() is producing yesterdays records - using date()+1 receives todays records. Does anyone know how to solve this. I'm using DWUD/IIS & Access.
Thanks in advance

 

[rajeessh]

Are u and your server at different domains???
IF IIS Server is at a diff domain this will arise Sir

 

[Guest_imported]

Thanks for the reply but we are not in different domains. Another interesting aspect of it is that after 12 midday the problem does not arise and day() works. For some reason clock relating to the database on the server is not GMT.

 

[rajeessh]

Sir i meant whether u and your IIS server at different time domains.
u at India and Server at US??????

 

[Dynapen]

It sounds like the date on the server is diferrent from what you expect it to be. It is possible that they have the date set 12 hours off.

Try doing a response.write against the date() to show exactly what time the server thinks it is. That should answer your question.

 

[royyan]

NewDate = DateAdd("D", 1, Date())