Share
Report
1,295Hi,
I have a table with Valid Time State field type set to Date. I have to write x++ logic to to validate ValidFrom and ValidTo of a new record with the exsiting records and get a validate info if date range is not appropriate rather than system throwing an error.
Lets say, I have three records for an item and vendoraccount with different date ranges.
| ItemID | VEndAccount | ValidFrom | ValidTo |
| 00008754 | 100098 | 12/1/2019 | 12/1/2021 |
| 00008754 | 100098 | 12/2/2021 | 5/6/2023 |
| 00008754 | 100098 | 5/7/2023 | Never |
I have to add a 4th record for the same itemid and vendoraccount with validfrom and validTo.
Is there a function or a keyword that checks right away than manually checking using a while loop query?
while select validtimestate(dateNull(),dateMax()) setuptable
where setuptable.VendAccount == this.VendAccount &&
setuptable.ItemId == this.ItemId
{
}
All responses (
Answers (
