Board index Office Access

Date syntax to show a year ago from current year and day

Date syntax to show a year ago from current year and day

Post by Dave Ellio » Thu, 06 Jan 2005 05:08:41



I need to adjust this syntx to show a years difference from the current
year and day.
Example; if it is January 1, 2005, (Now) then I need it to show January 1,
2004
Me.StartDate = DateSerial(Year(Date), 1, 1)
 
 
 
Top

Date syntax to show a year ago from current year and day

Post by Andi Maye » Thu, 06 Jan 2005 05:26:27

On Tue, 04 Jan 2005 20:08:41 GMT, "Dave Elliott"


Me.StartDate = DateSerial(Year(Date)-1,month(date), day(date))

---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

 
 
 
Top

1. find a date range between current date and 1 year ago

2. Efficient query for this year/last year/two years ago

3. Date order (month day year vs day month year)

4. Outlook show week number(1-52); day of year / days left in year

5. Adding days expired in current year and days remaining in current

6. Query for current year dates plus December of previous year??

7. Report to show current year revenue only if last year has no r

8. Formula for showing Previous Year - Current Year

9. Report to show current year revenue only if last year has no reven

10. current year autofilled when entering dates in future years

11. How do I set the calendar to show b-days year after year?

12. hOW DO I CHANGE THE FROM MONTH/DAY/YEAR TO DAY/MONTH/YEAR?

13. First Day Of Year AND Last Day Of Year

14. day of year and days left in the year?

15. Creating adataset of the day, month, year of every day for next year

All times are UTC
Board index