G
Guest
I only need what day it is from a date field. How do I pull apart the =Date() to just get today's day
Clut
The Access New Guy
Clut
The Access New Guy
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
Create an expression:
Format([longdate],"dddd")
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
Format([longdate],"dddd")
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
=Date() to just get today's day?Clutz said:I only need what day it is from a date field. How do I pull apart the
P
PC Datasheet
Look at the DatePart function in the Help file.
C
Chris Nebinger
Or, (as there is always several ways to do most things)
day(Date())
Chris Nebinger
day(Date())
Chris Nebinger
pull apart the =Date() to just get today's day?-----Original Message-----
I only need what day it is from a date field. How do I
F
fredg
I only need what day it is from a date field. How do I pull apart the =Date() to just get today's day?
Clutz
The Access New Guy
If this is in a control source, simply set the Format property to:
dddd
To get the full day "Monday".