date functions

  • Thread starter Thread starter franky
  • Start date Start date
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?
 
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.
 
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...
 
Back
Top