Calculate Date

[Superguppie]

Hey There,

i have 2 thingss......

in a table 1 have a begindate and enddate
and i have a checkbox named SLA
when the diff. is more than 24 Hours between begindate and Enddate SLA must be unchecked when it is less than 24 Hours, it must be checked (it can be: when more than 24 Hours it must be checked, and less than 24H it must be unchecked, that doesnt matter)

Also

In a form, a subforms will show a datasheet of a table. that table has also a begindate and enddate, the datasheet must show all record except the record of today.

how can those 2 thing be done

Thanks in advance

Greet
Superguppie

 

[MichaelRed]

please do NOT cross post. It is considered impolite and a waste.




MichaelRed