Get just the day from Long Date

C

Clutz

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
 
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
Clutz said:
I only need what day it is from a date field. How do I pull apart the
Click to expand...
=Date() to just get today's day?
 
C

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
Click to expand...
pull apart the =Date() to just get today's day?
 
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
Click to expand...

If this is in a control source, simply set the Format property to:
dddd
To get the full day "Monday".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Group Footer DLookUp 0
Using project as a resource tracker 0
Display weeks from a Milestone 0
Mail Merge skipping records/sending one at a time 0
Receiving unexpected Duration 0
Get the right language when inserting a date 2
A couple questions BEFORE using Office 365 0
Removing {PAGE/*MERGEFORMAT} from my microsoft document 5

Top