Days to yrs/mnths/days

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roby - 31 Mar 2007 08:28 GMT

I have a form that calculates senority. So Start date to Now() gives me a day
rating say 3011 days. How would I extend the below code so the ranking reads
yrs/mnths/days?? Any help would be greatly appreciated!

Here is the code I am using to get it to days;
=DateDiff("d",[Hire Date],Now())

Thanks

Reply to this Message

Allen Browne - 31 Mar 2007 09:19 GMT

Here's a couple of options that provide more than the basic DateDiff():
http://www.accessmvp.com/djsteele/Diff2Dates.html
http://www.pacificdb.com.au/MVP/Code/Age2.htm

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a form that calculates senority. So Start date to Now() gives me a
>day
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Daniel - 31 Mar 2007 11:38 GMT

Take a look at

http://localhost/web/CARDA/en/msaccess.php?lang=en&id=0000000011#age

it should be exactly what you're looking for.

Signature

Hope this helps,

Daniel P

> I have a form that calculates senority. So Start date to Now() gives me a day
> rating say 3011 days. How would I extend the below code so the ranking reads
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message