Get just the day from Long Date

[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

 

[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

I only need what day it is from a date field. How do I pull apart the

=Date() to just get today's day?

 

[PC Datasheet]

Look at the DatePart function in the Help file.

 

[Chris Nebinger]

Or, (as there is always several ways to do most things)

day(Date())


Chris Nebinger

-----Original Message-----
I only need what day it is from a date field. How do I

pull apart the =Date() to just get today's day?

 

[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".