Split a date

R

Ripper

I want to use the separate parts of the current date mm/dd/yyyy against a
value to determine if the database ran out of date and needs to be
re-purchased etc.

How can I pull apart the current date and then use the pieces in a formula
to get a value?


EG: mm*100+dd+yyyy= [Some Value]
 
J

John Spencer

Month(SomeDate)*100+Day(SomeDate)+Year(SomeDate)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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

printing report with date 3
Date format when exporting 2
Correct date format 2
Text to date format? 0
Stored date is not being recognised 1
FILTERING A FORM WITH A DATE 3
convert date 1
Special Date Input Settings 2

Top