Date () Function Issue

[efinnen]

Hello All

I have hopefully a simple question that someone can help me out with. I've created an MDB. That has several VB functions involving the Date() command. They seem to be working fine on Windows NT and Win 2k. They are however blowing up on Win 98 machines.

For what its worth all the References are exactly the same cross all platforms.

Sample Codes that Blow Up on Win 98. Also tried as Date and Date()

Me.LastModifiedDate.Value = Date

and this one is a SQL statement in the Report Query Builder
TurnAround: IIf([usystblPEL50]![Status]="Open","OPEN " & Date()-[usystblPEL50]![DateInitiated],[usystblPEL50]![DateClosed]-[usystblPEL50]![DateInitiated])

Thanks for any suggestions.
-eric

 

[vbajock]

Try Now() in the place of date()

 

[judgehopkins]

Also, check the regional settings on the Windows 98 machine.

Start/control panel/regional settings...if my memory serves.

Judge Hopkins

http://www.psc.state.mo.us/adjudication.asp

There are only two rules for success: (1) Never tell everything you know.

 

[efinnen]

I had used the Now() function instead of the Date() function on the WIN 98 machine previously and it worked sorta... I guess I'll just end up INT() the result I get to shave the decimals...

The curious part of me still wants to now why it doesn't work in Win 98 anyone have any clues....

Thanks Again
-eric