InfoPath Dev

The date field does not work in an InfoPath, SQL external list. The date and time field does not matter about the time, but it would be great to not output the time. Only the date input for the date and time data type is important; therefore, 081515 to 8/15/2015 ... 81515 to 8/15/2015.. etc. [quote user="donstephen"]I am ...

A pattern for the TEXT date type would be the same as the currency format pattern; however, i do NOT want to use the integer or decimal data type A $ dollar sign symbol before all number and a comma before any three digit symbol.

Everything works! However, I want to used the " Date and Time (dateTime) " data type not the date data type. Can you create an example with using the Date and Time (dateTime) " data type? possibly using the same rules.

Are there functions and conditions to create our own currency format? Let me know, thank you! I will post a solution, once I find one. [quote user="donstephen"]I am still unsure why you need a validation to allow numbers only. I am pretty sure you don't need to add the validation rule since setting the data type ...

When I enter (51615) the dates does not output (5/16/2015), the output is actually the following: concat("20", substring(translate(., "/", ""), 4, 2), "-0", substring(translate(., "/", ""), 1, 1), "-", substring(translate(., "/", ""), 2, 2)). The second ...

I have tried the formula in the Date Picker Properties for the value, but it did not work. I am working on building a formula as well. See attachment for the occurring error in the sample form except it is a local form and not from a external list.

Hi donstephen, Since SQL databases only use date and time (data types), I am testing the same rules and conditions. The rules and rule condition works with the date picker; however, the input recognition is not working. The date is backwards. See image below. [quote user="donstephen"]Hi Davydcondy, I am ...

Validation Pattern: DollarCurrency > does not match pattern > Custom Pattern: $?[0-9]+ Run type: Action Set a field's value = translate(ExternalFieldInteger, "$,", "") The issue occurs when there are symbols in the field. This happens only when viewing (retrieving) the field from the ...

I am not getting an error. The issue that I am having is by connecting two fields to mask the original value from the external content type list. After publishing the form with the rules, the input data will not be save to the list.

The rules with action formulas work; however, I am unable to save the values. Do you have any solution ideas for the occurring issue?