I created a new user field with DateTime data type.
I then added new edit box to my form for this new field.
I then programmatically populate the field with current date based on checkbox click event using this code:
... ThisForm.Components("editReleaseDate").value = Now.ToString("MM/dd/yyyy") ...
The date appears correctly in the box '5/17/2019', but when I click the SAVE button I get error message that the date is in incorrect format.
So I added the following code just to see what the actual value was it was trying to save: msgbox (ThisForm.Components("editReleaseDate").value)
and the message box says the value is '2019/5/17'
I have gone around and around trying to get the correct date, using different date formats. Nothing works.
INTERESTINGLY if I click in the date field and then click SAVE it works.
Any suggestions? I know Syteline has regional date format settings and I think I am bumping up against that?
Maybe if I SET FOCUS to the edit box - but I couldn't figure out how to do that either. HELP!