convert date to decimal

# Thread: convert date to decimal

1. Senior Member
Join Date
Dec 1969
Posts
358

## convert date to decimal

How do you do it? Thank You :)

2. Senior Member
Join Date
Dec 1969
Posts
2,930

## when you say decimal...

i&#039;m sorry, i don&#039;t understand<BR><BR>http://www.dictionary.com/search?q=Kludge

3. Senior Member
Join Date
Dec 1969
Posts
358

## RE: when you say decimal...

well, I want to be able to convert 5/14/02 to a decimal form, ie(.234) I&#039;m not sure if this is possible or not, but it&#039;s a just a question.

4. Senior Member
Join Date
Dec 1969
Posts
2,930

## RE: when you say decimal...

oh... well, you can get all the values out of that date by using the Month, Day and Year functions and store them in m, d and y respectively. you could then divide them like this: m/d/y which would return 1.7839303553589267874982160696446e-4 for today. don&#039;t know if this is what you want

5. Senior Member
Join Date
Dec 1969
Posts
905

## Ok, I'm confused...

...were your examples related because I couldn&#039;t quite see it.<BR><BR>You can convert a date to its numeric value which the system use&#039;s by doing CDbl(Date()).<BR><BR>Not sure what you are trying to acheive here though.<BR><BR>Matt

6. Senior Member
Join Date
Dec 1969
Posts
358

## Actually.....

You just did answer my question, the problem was that I was having trouble wording the question properly. I appreciate your help. Thank you!! :)

7. Senior Member
Join Date
Dec 1969
Posts
905

## Wow! Accidental victory. <eop>

.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•