I am creating a form and the date that I need to insert in to the database needs to be in a YYYYMMDD format. I can't seem to find a way to do that in App Connect. Any ideas?

Hi Kathleen,

How are you inserting the date into the database - is it using a text field?
What exactly would you like to format - the value which the users enter in the text field or the value that gets inserted in the database?

It is being inserted into the database as a smalldatetime data type. If the input can be formatted as the user enters the date then that would be fine but if need be it can be reformatted as it enters the database.

Hi Kathleen,
I am afraid it is not possible to format the date (like using masking) while the user is typing.
Maybe you should just use a date field, and convert the value using server data formatter on insert.