• Innovator SQL Procedures vs. Date Format - how to prevent conversion to American date format?

    Hi community, I use an Innovator SQL procedure to get some data that is merged with a second database. The SQL procedure is called from a server Method When I test the procedure in SQL, date properties like modified_on are shown as in correct regular…
  • Setting Short Date Time property with server C# method

    Hello, I am trying to set a Date property that has a Pattern of Short Date Time with the below code. Even though it is yyyy-MM-dd hh:mm:ss tt in the string it is still saying that it is not formatted correctly? Below is the code and the error. Thank…
  • Is there a way to check the consumed License Feature expiration date/time?

    I logged in using user1 and I consumed a feature license. I checked the license manager in the aras client and saw the consumed license of user1, I left it overnight and check the license manager the next day the consumed license is gone. Is there a way…
  • C# SQL Date Query

    Good day all, I am trying to create a dynamic report to produce the time it take between starting an activity and ending an activity. I can get the information I am looking for by using SQL, but it will not limit the returns based on dates. I have tried…
  • Is it possible to sort only by date and not time for "short_date_time" type of column

    Hello, Please confirm is it possible to have this the sorting specification of the search grid. If a date type property is specified as a sort key, is it possible to switch sorting by pattern? (1) When the pattern is "short_date_time", sorting including…
  • Date issue, user date selected different from date in DB

    Why the date selected by user in aras form is different from the date in database?
  • Create a new Action Items when it passed its Target Date

    The user needs to create an action item in the Issue form even if it’s past its Target Closure Date. The options by providing the following update: 1. Allow anyone assigned as an Issue Champion (whether a group member or an individual user) to add any…
  • Problem with the use of dates.

    Problem with the use of dates. I'm going to go crazy with ARAS. After several hours using dates, and it didn't work out, I discovered date is stored in the databse in "neutral" date, here in Spain it is +1. That's why the "GET" did not work for me,…
  • Searching by effective date when adding relationships

    Hello - We have an application built within Innovator that is similar to the Digital Twin concept, with configurations of components within modules tracked as versions of the module item, and 'hard fixed' relationships between the recorded jobs and…