• 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…
  • 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…
  • Change Date Format in Calendar Control Date field

    I have a date field in my custom form that is not bound to any item type. The Calendar Control Time selection is disabled by default as the default format is Short date. How do i change this to long date so the time selection is enabled?