So I'm trying to create a serial number for form entries based on location, department, date and time. I've added scripting to convert the locations and departments to numbers and I want to add the date and time to the ends. I'm using the concatenation formula to do this. and everything seems to be easy enough except the date. When I type in the date, it is returned as I type it. But when I use the calendar drop down it is bound in a euro format "YYYY-MM-DD". I changed the binding format to MMDDYYYY, but it doesn't effect anything. I want the user to be able to use the calendar tool, but can anyone tell me how to override it's default format?
You might want to look at the various 'format' options available. I prefer to set the display format and use the 'formattedValue' as this approach provides a known result no matter what is entered or LiveCycle Designer decides to default to. There is also the 'rawValue' and 'value'. 'rawValue' provides the entered data and 'value' is the assumed or default format value being used by the opened version of LiveCycle Designer.
I've tried several different variations using Format, formattedValue, and DateFmt. If I type in the date it saves the data as what I type, but if I use the Calendar pop-up, it's still giving me a format that I don't want. This is frustrating.
At the very least I would like to figure out how to omit the dashes in the data format, YYYY-MM-DD.