Format Problem - Time

  • Thread starter Thread starter Lee-Anne Waters via AccessMonster.com
  • Start date Start date
L

Lee-Anne Waters via AccessMonster.com

Hi,

i have a national database on terminal server and i need to be able to
calculate the current time in a specific region. WA for instande is 2 hours
behind QLD.

this is the formula i have thus far but i cant get it to show the current
time in hours and minutes less the two hour time difference

Local: IIf([tblOrdersMain]![REGION]="WA",Format(Now()-2,"Short Time"),"")

any help appreciated.
Thanks
Lee-Anne
 
Try this:

Local: IIf([tblOrdersMain]![REGION]="WA",Format(DateAdd("h",-2,Now()),"Short
Time"),"")


FYI...the reason it wasn't working with your expression is that you were
subtracting 2 days when you used
Now()-2
 
Back
Top