Access Date Problem - PCMech Forums

11-06-2003, 09:22 PM	#1
eskimo Registered User Join Date: Jun 1999 Location: Huntingdon. UK Posts: 215	Access Date Problem Hi All Trying to get dates DOB 18-Aug-53 to age on the 8th 1st at the present time then to age at present. After the DOB keep getting #NAME in the next 2 boxes instead of a value DOB first ="Age on " & DateSerial(Format(Now(),"yy"),8,1) & ":" =DateDiff("yyyy",[DoB],DateSerial(Format(Now(),"yy"),8,1))+Int(Format(DateSerial(Format(Now(),"yy"),8,1),"mmdd") why does this not work? Share Share this post on Digg Del.icio.us Technorati Twitter

Bookmarks

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Trackbacks are On Pingbacks are On Refbacks are On Forum Rules