How to add date to new edit box

Legacy Contributor

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!

 

Legacy Contributor

There are keywords that you can use that can help to populate the default date in the appropriate format. In the default box for the component enter CURDATE(). This will populate the component with the current date correctly. You can also use CURTIME() as well if you need the time for the record too.



Let me know if this helps.



Paul