Code Expression
Hi Kindly refere to the attached screenshot before you read the below query so that it will make more sense.. I need to enter today's date in my date cell (called effective end date) for whic...
Forum Discussion
It looks like issue when you use Keys() method.
Have you tried SetText() function? if not please try using this.
Then i would suggest to select by using calendar object which you will get by clicking down arrow.
Yes that is an option but that option doesn't allow me to enter yesterday's date and that's the reason I was wondering if using code expression can sort that issue.
gdavewrote:Just tried Settext function, my test doesn't fail but it does not populate date in the date field as well.
shankar_rwrote:It looks like issue when you use Keys() method.
Have you tried SetText() function? if not please try using this.
The code expression, as it is, is correct. So, that's not the issue.
Here's my guess... and I'm not 100% certain... but it looks like your control may be applying some auto-formatting.
If you were to manually type the value into that field, do you need to add the "/" characters or are they automatically added by the control? What happens if you change the code expression to remove the slash characters?
Although, this may only delay the problem because, if you get to a day of the month that is single digit, you may still need to have some way to go to the next field. So... as suggested, rather than using keys, there may be some other method or function you might need to try. Examine the properties of your control to see if there is something like a "wDate" field or something else that you can set the value of rather than using the "Keys" method.
