<div>
Hi,<br />
<br />
Since the access date is correct, it sounds like the web app is not adjusting for daylight time. &nbsp;You need to determine where the date/time is coming from on the web app.<br />
<br />
Regards,<br />
<br />
Bill
</div>


Hi,

Since the access date is correct, it sounds like the web app is not adjusting for daylight time.  You need to determine where the date/time is coming from on the web app.

Regards,

Bill

<div>
@Bill - Ok, thanks. So most likely the jvm timezone settings are different than the o/s. <br />
<br />
<br />
@Nemetona - What timezone is your o/s using? Also, please run <a href="https://www.experts-exchange.com/questions/28171831/Time-discrepancy.html?anchorAnswerId=39288411#a39288411" rel="ugc">the CF debugging code above</a> and post the results.
</div>


@Bill - Ok, thanks. So most likely the jvm timezone settings are different than the o/s.


@Nemetona - What timezone is your o/s using? Also, please run the CF debugging code above [https://www.experts-exchange.com/questions/28171831/Time-discrepancy.html?anchorAnswerId=39288411#a39288411] and post the results.

<div>
I have been move to a different project and need to park this for the time being. &nbsp;Thank you both for having responded.
</div>


I have been move to a different project and need to park this for the time being.  Thank you both for having responded.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a web application (ColdFusion) and an MS Access 2003 application both working from the same server.<br />
<br />
If I print out the current time using Now() on a web page and in an MS Access vba immediate window I get a discrepancy.<br />
<br />
The web application shows me the hour is 16:58 while the MS Access shows me the hour is 17:58. &nbsp;From my point of view the 17:58 is correct.<br />
<br />
Can someone tell me how I can find a work around for this discrepancy.
</div>
</div>


Hi

I have a web application (ColdFusion) and an MS Access 2003 application both working from the same server.

If I print out the current time using Now() on a web page and in an MS Access vba immediate window I get a discrepancy.

The web application shows me the hour is 16:58 while the MS Access shows me the hour is 17:58.  From my point of view the 17:58 is correct.

Can someone tell me how I can find a work around for this discrepancy.

Time discrepancy

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.