Mindbending problem with dates

  • Thread starter Thread starter Julian
  • Start date Start date
J

Julian

I have a form that people enter into at least once a
month but never a set number of days. Is it possible to
subtract one date from another to get amount of days
since last read date or similar? I have a unique
refrence of a dropdown in a table which I want to relate
the calculation to.

for example -

someone opens the form, upon selection of choice in
combobox fed from a table with all unique values is
chosen I need to check in the database to see when the
last date was entered for that unique value and subtract
that date from the current days date.

I hope that doesnt sound like too much gobledeygook!!

with thanks

Julian
 
Back
Top