InfoPath Dev

So - yeah, that seems weird. Your form seems right. You might want to try adjusting postback on the textbox where you are entering the data, see if that fixes it.

Here is my file :) Thank you!

My apologies, I had mistyped the last two formats I had tried which were: format(DateTimeField, 'yyyy-dd-MMTHH:mm:ss'), format(DateTimeField, 'yyyy-dd-MMTHH:mm:ss'). In your previous response you had the date as yyyy-dd-MM but you just suggested 'yyyy-MM-dd' so I did swap the month and day and that did work. So thank you ...

I don't understand why you formatted your date time to use a slash when you need to use the dash, as per all my earlier posts. Or why you are using a different format than what I suggested. As I've said, you need to format in a date time format that XML uses, which is yyyy-MM-ddTHH:mm:ss Edited to add a sample date time - using ...

Thank you. So I have edited my SQL statement to read like so: format(DateTimeField, 'MM/dd/yyyy HH:mm:ss'), format(DateTimeField, 'MM/dd/yyyyTHH:mm:ss'), format(DateTimeField, 'yyyy/dd/MM HH:mm:ss'), format(DateTimeField, 'yyyy/dd/MMTHH:mm:ss'). These all when returned show as I specify but still have the red ...

This seems to work as anticipated to me - see attached sample.

Take a look at the conditional formatting on the section - I'm just checking if the ID of the Vendor matches the selected Vendor. I made a modification to the new section in this sample - one thing that might also help while trying to work out the formatting is to change the conditions from hiding to just highlighting with a color.

Could you attach your latest template to a reply so I can take a look? :)

But after I have added a new item, it calculates correctly. I dont know where this is coming from. Thanks your your help!

I think we almost got it. Ive added a calculating fiel. But if I type in my data It calculates something really strange