date functions

F

franky

I have a table with a date field. How would you find out
the weekday this value is today as opposed to its
original weekday?
 
R

Rick Brandt

franky said:
I have a table with a date field. How would you find out
the weekday this value is today as opposed to its
original weekday?
Click to expand...

Original weekday? If a particular date was a Tuesday when
will it ever NOT be a Tuesday?

Format([YourDateField], "dddd") will give the day of the
week for the date in the input field. It will produce the
same result for a given date no matter when you run it.
 
F

frandy

brain fart! sorry


-----Original Message-----
franky said:
I have a table with a date field. How would you find out
the weekday this value is today as opposed to its
original weekday?
Click to expand...

Original weekday? If a particular date was a Tuesday when
will it ever NOT be a Tuesday?

Format([YourDateField], "dddd") will give the day of the
week for the date in the input field. It will produce the
same result for a given date no matter when you run it.



.
Click to expand...
 

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

2016 Project, adding a workday to custom field 0
Web Layout in Word on Android 0
Doughnut Chart linked with the slicer in the pivot table 0
Search closest day in the past from today 2
Complicated Date Calculation needed 5
Assistance with vbYesNo 3
Dcount -Date Criteria - Won´t find it - 0
Date diffrence in days, weeks and months. 1

Top