How to create and get ms access translate function?

Asked By madly madly 0 points N/A Posted on - 03/18/2013

I need some translation function for ms access. As for example I need to translate a numeric date to total numbers of days from the date to today. Where can get such Type of ms access translate function? I also want to learn and create some myself.

• Status: Open
• Question Views: 913
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By James D Costanza 60 points N/A #157877

How to create and get ms access translate function?

 

Hi Madly,

In Access dates are usually stored as numbers, so you can get correct answer by simply subtracting one date from another.

You can also get absolutely correct answer by using function DateDiff(). It will give exact number of days between days.

I hope it will help you!

About James D Costanza

Questions
116

Answers
11

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/03/2013
• Question Category: MS Access