Hi!
What I'm trying to do is find a way to standardize the date formatting from an SQL lookup. The reason why I need this is that dates are stored in SQL in yyyy-MM-dd format, but are being displayed in Forms as dd/MM/yyyy. I'm trying to do a simple lookup in Forms by populating the dropdown with all the dates in SQL, then bringing up the row where the date matches from that same table.
I've changed the default system clock on both the machine running Forms Server, as well as the client machine, but that didn't help. I've also changed the RoutingService config file, set ignore language to true, and specified the date format default I'd like, and that also didn't work.
It's worth noting that this setup worked last week, but the dropdown was being populated with a datestamp instead of a converted short date. Not certain why that happened, to be honest.
I've added two screenshots; one of the drop down population lookup, and one of the table populating lookup. The dropdown population works, but the table one does not.
Thanks!
Peter