Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 2 of 2 (18 items) < Previous 1 2 Re: Whole Number (integer) for Currency Format I have just create a validation rule and a XPath Function action. It's not working on my InfoPath form See conditions below: [quote user="Hilary Stoupa"] The list may be returning decimal values - which would explain the error. You may need to put the field on the form again, and set it to ... Posted to Controls (Forum) by davydcondy on 09-24-2015 Re: Date format in date control field type It has been working! Thank you so much for the advice and contribution. I have another issue with a fields using the whole number (integer) for Currency Format. Please see the link: http://www.infopathdev.com/forums/p/30509/104107.aspx#104107 Posted to Controls (Forum) by davydcondy on 09-23-2015 Whole Number (integer) for Currency Format The input of any currency will work such as 2000000 and it will convert to $2,000,000 However, I am also using the form to view data from a list while using the InfoPath form. I have wrote a few pattern validation rules, but the error "Only integers allowed" (see below) continues to persist. Posted to Controls (Forum) by davydcondy on 09-23-2015 Re: Date format in date control field type Thank you so much, because it was becoming complicated. This strategy worked great! However, I am also using the form to view data from a list while using the InfoPath form. The Microsoft SQL only has the date and time format as (5/15/2014 8:00 PM) and output in the InfoPath form as 2014-05-15T20:00:00 What would be another ... Posted to Controls (Forum) by davydcondy on 09-22-2015 Re: Date format in date control field type I have added a similar field's value for a text box; however, it will break the concepts of date picker. The data function works for any date such as 09202015 to (09/20/2015). Here is the formula I have used: concat("", substring(translate(., "/// ", ""), 1, 2), "/", substring(translate(., ... Posted to Controls (Forum) by davydcondy on 09-21-2015 Date format in date control field type When using InfoPath, the default DATE data type does not have a input recognition when entering only digits such as (41315) to (4/13/15). How to change the user input automatically of number/digits into a date format? Posted to Controls (Forum) by davydcondy on 09-14-2015 Date mask field in infopath 2013 I am working in InfoPath forms and the Date(date) data type. The user has the data picker; however, I want user to be able to input a date with just number and the data will automatically change into a date format as (091615 into MM/DD/YYYY). The user can also enter MM/DD/YY and turn into MM/DD/YYYY or the user can enter M/D/YY and the format ... Posted to Controls (Forum) by davydcondy on 08-06-2015 Searching an external list and edit any item found The things I have are an InfoPath layout form to edit and submit items into a external BCS list. I have a SQL database connection in SharePoint. I found a web part (Business Data List) to search items within a external content type connection, but I cannot edit any item found by this webpart? is there a link to link the default list view style ... Posted to General (Forum) by davydcondy on 08-06-2015 Page 2 of 2 (18 items) < Previous 1 2 Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.