tag:blogger.com,1999:blog-8134759511126815909.post905119684398311037..comments2023-08-20T04:10:01.095-04:00Comments on <a href="http://rogersaccessblog.blogspot.com/">Roger's Access Blog</a>: Date Stuff–FunctionsRoger Carlsonhttp://www.blogger.com/profile/12265719129831415014noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-8134759511126815909.post-13173649379170081932018-04-23T08:26:21.363-04:002018-04-23T08:26:21.363-04:00Extremely useful !!!!Extremely useful !!!!dcithttp://www.dcit.ch/noreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-46857489783870979782013-07-31T17:43:37.024-04:002013-07-31T17:43:37.024-04:00Date() does not seem to work in Access 2013 Int(No...Date() does not seem to work in Access 2013 Int(Now()) seems to work but Date() just produces an unknown function errorAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-822054834902848632013-03-19T13:01:54.694-04:002013-03-19T13:01:54.694-04:00As Anonymous pointed out, the use of DateDiff abov...As Anonymous pointed out, the use of DateDiff above won't work. I think this should work though:<br />Int(DateDiff("d",[DOB],Now())/365.25)<br /><br />Or you could use DateDiff as above and add an IF statement to see if the day has passed yet or not.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-32259362599640979262012-12-09T19:54:11.037-05:002012-12-09T19:54:11.037-05:00The DateDiff function as shown doesn't work to...The DateDiff function as shown doesn't work to produce ages - it gives the age that the person became that year, whether now is before or after the birthday.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-66355456406383268462012-12-07T14:50:57.552-05:002012-12-07T14:50:57.552-05:00Anonymous on Dec 4 doesn't have it quite right...Anonymous on Dec 4 doesn't have it quite right. It should say "will evaluate to December 1 even if you meant January 12."Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8134759511126815909.post-11242548272942618822012-12-04T11:43:32.751-05:002012-12-04T11:43:32.751-05:00In the following:
You have to be a little careful...In the following:<br /><br />You have to be a little careful if you don't use the US Standard date format of Month Day Year. CDate will correctly interpret both "1 December, 2011" and December 1, 2011" as 12/1/2011. But "12/1/2011" will evaluate to December 12 even if you meant it to be January 12. <br /><br />It should say "will evaluate to December 1", not "December 12"Anonymousnoreply@blogger.com