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]
 
Ad

Advertisements

Ad

Advertisements

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


Top