Working on data synchronisation with legacy system I faced interesting question in valid time state table area. Please find the details below.
Problem description
Create a method to check whether a record in valid time state table is valid now.
Steps to reproduce
1. Find or create new valid time state table
2. Create 3 records: valid in past, valid now, valid in future.
3. Test the method on each record
Hints
There are at least two solutions:
1. Try to select the same record from database. Kernel adds Date or DateTime ranges and nothing is returned if the record is not valid now.
2. Compare values of ValidFrom and ValidTo fields with now. Analyse and define now for Date and DateTime.
