Browse By Tags

  • Getting name property mismatch error while changing data type - Text to Date

    The Property has data type Text and we are trying to set to Date on that time we are getting : - does not match the required 'name' property pattern: ^[a-zA-Z](\w*| +\w+)*$]] Request: <Item type="ItemType" id="5738793931D64D938F02558135C20FE8" action…
  • 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…
  • What is the correct way to parse DateTime on a server side onAfterGet event?

    Hi everyone. I'm currently trying to evaluate the current date and a date property however, when I try do parse the string provided by getProperty, it gives me the error: String was not recognized as a valid DateTime. I can confirm the property…
  • 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?
  • Report Date Format

    Good day all. I am trying to set up a custom report that will return the item_number, name, & revision_date for documents. The information is eing output, but the revision_date includes the time. How do I set it so it will only include the date? Thanks…
  • How to find the date difference from 2 fields.

    Hi i have a question and i would really love to get help. i currently allow user to select a start and a end date. with this information i want to calculate the number of days. I have tried coding this myself but i keep getting errors. string startDtStr…
  • On Change Event of Date Field

    Hi I want to trigger some action on change of a date field in custom form. This form is not added to any item type. I tried add On Change Field event to form but it is not triggered. Please let me know how to achieve this Thanks
  • How to search for 'Yesterday'?

    I want to find all part Items with a created_on date of Today - easy. Now I want to Save this search to the TOC so users can run it daily - not so easy. I am trying to search for "Yesterday" in a date field, using AML. this: <Item type="Part" action…