Group: microsoft.public.access · Group Profile · Search for zulu time conversion in microsoft.public.access
Author: BruceM
Date: Sep 18, 2008 07:55
I'm not sure why that worked at all. See Help for information about DateAdd. You could put something like this as the control source of an unbound text box: =DateAdd("h",-7,[zulutime]) This will probably show you the date and the time, including seconds. Adjust the format as needed, either by selecting a preset format for the Format line on the Format tab of the text box Property Sheet
|