Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I have a table that has Validate TimeState property set to Date.
I want to do a select on all records (not only the current ones) but the query is restricted only to the current records.
Do you have any idea how to avoid this?
Yes, there are query options to "override" the default checking. I blogged about this quite a while ago, you can find the explanation and examples here:
There is also quite a bit of info on MSDN on the topic.
Dynamics AX MVP | My Blog | Sikich | Twitter @JorisdG
Thank you for your answer.
I actually wanted to remove all kind of date ranges in my query.
So select all records no matter if they have a date in a range or not.
I don't know if it is possible with the validateTimeState being set.
you could use datenull() and dateMax() as the values for the from and to date.
Setting validTimestate(dateNull(), dateMax()) in the select statement will create a restriction.
select validTimestate(dateNull(), dateMax()) from Table1
is equivalent to
where FromDate <= dateNull() <= dateMax() <= ToDate.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics