Board index Office Access

Printing a fixed date next year

Printing a fixed date next year

Post by Robin Chap » Sun, 31 Jul 2005 10:00:32


I need to print membership cards which show

"Valid to June (Next Year)" always.

I have adapted some earlier advice to build both of these options
which work but seem clumsy.

="Valid to June " & DatePart("yyyy",Date()+365)

="Valid to June " &
Year(Date())+(Date()<DateSerial(Year(Date()),7,2))+1

Is there an easier piece of code?

Thanks,

Robin Chapple
 
 
 
Top

Printing a fixed date next year

Post by Ken Snell » Sun, 31 Jul 2005 10:33:28

Easier? I leave that to you as a conclusion:


="Valid to June " & Year(Date()) - (Date() > DateSerial(Year(Date(), 7, 0))

or

="Valid to June " & Year(Date()) - (Month(Date()) > 6)

--

Ken Snell
<MS ACCESS MVP>

 
 
 
Top

Printing a fixed date next year

Post by Tom Lak » Sun, 31 Jul 2005 15:00:35

>I need to print membership cards which show

Does this do it for you?

= "Valid to June " & Year(Date()) + 1

Tom Lake
 
 
 
Top

1. Printing report b after report a prints using report a's variables

2. how do print the next 30 dates from any date

3. Year-to-date year to date formula

4. Changing worksheets to the next years dates

5. AVC/JCU announces date for next years show

6. Occurance on a specific date each year or the next working day?

7. date based info to next years calendar

8. Trying to get the next date exactly 5 years ago..

9. AVC/JCU announces date for next years show

10. After 12 years I got a date with my former girl next door

11. Loop through date range, but skip down to next year

12. type date for next year

13. Rounding Date to Next Half Year

14. Print current and next three years

15. [PHP] Print current and next three years

All times are UTC
Board index