It's possible with a custom function (requires the Advanced version) or with a repeating calculation field. What would be the purpose of such calculation?
I need it in a relationship between 2 tables
Table = Table 2
Why not make the relationship:
Table 2::StartDate < Table::cCurrentdate
Table 2::EndDate > Table::cCurrentdate
Sometimes it's so simple...