Hi,
Sorry if this has already been asked. I tried seraching the forum but couldnt find a similar post.
I have an InfoPath Form with a Repeating Table which contains a Date control and a Check Box.
I need to perform a Concat on all of the Date fields where the Check Box is false / unchecked. This is a simple enough process using a combination of Eval and Concat but the issue I have is with the format of the actual Dates. They are displaying in YYYY-MM-DD - I may be wrong but I believe this is the standard format used by XML.
In the past I have then used the Substring Function in order to extract the individual Day, Month, Year values and then Concat them together. I'm having a much harder time trying to nest this with the Eval function though. I think I'm pretty close (if this is even possible) but I think my syntax is a little off towards the end. What I have so far is as below where DATE and SIG_BOX are my fields:
eval(eval(DATE, 'concat(substring(DATE[SIG_BOX = string(false())], 9, 2), "/", substring(DATE[SIG_BOX = string(false())], 6, 2), "/", substring(DATE[SIG_BOX = string(false())], 1, 4)), " ")'), ".."
I have used these functions seperately numerous times before (even if I dont fully understand them) but never all 3 nested like this. Does anyone know where I might be going wrong here?
Thanks for any help you can give me.