DMXzone App Connect Support Product Page

I would like to change the input validation of a date to YYYYMMDD. How can I do that?

Asked 21 Jun 2018 19:44:23
has this question
21 Jun 2018 19:44:23 KATHLEEN SHURYN posted:
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?


Replied 22 Jun 2018 06:39:55
22 Jun 2018 06:39:55 Teodor Kuduschiev replied:
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?
Replied 25 Jun 2018 12:36:04
25 Jun 2018 12:36:04 KATHLEEN SHURYN replied:
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.
Replied 26 Jun 2018 12:46:34
26 Jun 2018 12:46:34 Teodor Kuduschiev replied:
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.

Reply to this topic