ValidTimeState table - How to get the inactive(not just active) records?

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi there,

How is it possible to get the active as well as inactive records in a date range… ?

while select validTimeState(fromDate, toDate) rateTable
where rateTable.RateID == ‘DAXMusings’
{
info(strFmt("%1: %2 - %3",
rateTable.RateID,
rateTable.ValidFrom,
rateTable.ValidTo));
}

It makes sense If I want to grab the active records during this date range, but what If I want active as well as inactive records?

2

Set fromDate = dateNull() and toDate = dateMax() to return all records.