[AccessD] substract dates

pedro at plex.nl pedro at plex.nl
Thu Sep 30 10:39:06 CDT 2010


Dear List,

i have two tables

tbl1
patientnr        Afsluitdatum
01234567    01-01-2010
09876543    15-01-2010	

tbl2
patientnr      Uitvoerdatum
01234567    01-02-2009
09876543    01-01-2009

I would like as result a new table that subtracts UitvoerDatum from Afsluitdatum, and when the result is within 365 days, i need a "1" and when the result is more then 365 days, i need a "0".

So the result is:

patientnr         days      value
01234567       334         1
09876543       379         0

Normally i do this in Excell, but i would like to do everything in access and not part in access and part in excell.

Thanks

Pedro



More information about the AccessD mailing list