(Msg. 1) Posted: Sat Aug 16, 2008 5:18 am
Post subject: Date Fields Archived from groups: microsoft>public>access>gettingstarted (more info?)
In my database, I have a date and time field. Using conditional formatting, I
would like to highlight this date on a form when the entered date = today.
The condition "must equal Date()" works if my date field only contains a
date. If my field contains a date and time, the solution does not work. I
think it has to do with the Date function equaling the date at 00:00 so it is
not a perfect match? I need the function to ignore the time in my field.
(Msg. 2) Posted: Sat Aug 16, 2008 7:30 am
Post subject: Re: Date Fields [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Sat, 16 Aug 2008 05:18:02 -0700, CaptPhil wrote:
> In my database, I have a date and time field. Using conditional formatting, I
> would like to highlight this date on a form when the entered date = today.
> The condition "must equal Date()" works if my date field only contains a
> date. If my field contains a date and time, the solution does not work. I
> think it has to do with the Date function equaling the date at 00:00 so it is
> not a perfect match? I need the function to ignore the time in my field.
Using Conditional Formatting, set Condition1 to
Expression Is.
Set the Expresion to:
DateValue([DateField] = Date()
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
(Msg. 3) Posted: Sat Aug 16, 2008 9:21 am
Post subject: Re: Date Fields [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"fredg" wrote:
> On Sat, 16 Aug 2008 05:18:02 -0700, CaptPhil wrote:
>
> > In my database, I have a date and time field. Using conditional formatting, I
> > would like to highlight this date on a form when the entered date = today.
> > The condition "must equal Date()" works if my date field only contains a
> > date. If my field contains a date and time, the solution does not work. I
> > think it has to do with the Date function equaling the date at 00:00 so it is
> > not a perfect match? I need the function to ignore the time in my field.
>
> Using Conditional Formatting, set Condition1 to
> Expression Is.
> Set the Expresion to:
> DateValue([DateField] = Date()
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
> Thanks, Simplicity, just what I wanted.
(Msg. 4) Posted: Sat Aug 16, 2008 1:41 pm
Post subject: Re: Date Fields [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Where YourDateTimeField is the name of your control holding the date/time
data.
Date = Left([YourDateTimeField],Instr([YourDateTimeField]," ")-1)
--
There's ALWAYS more than one way to skin a cat!
(Msg. 5) Posted: Sat Aug 16, 2008 4:02 pm
Post subject: Re: Date Fields [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I knew there was a native Access function that would pull the date part from
a date/time field, Fred, but I couldn't for the life of me remember what it
was called!
;0)>
--
There's ALWAYS more than one way to skin a cat!
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other