12-29-2016, 10:46 AM
Greetings,
While choosing date on a web control calendar, the QM program chooses the first date found on the calendar.
That is if the calendar is showing December 2016 dates, there would be November 2016 last week dates also showing up.
If the program has to choose today's date (29 December 2016), it chooses the first '29' on the calendar, which is 29 November 2016.
How to make the program understand to choose 29th December 2016 instead.
Right now the program first chooses the date from Excel and obtains just the day as below:
Macro RO Sales VISTA - Current
...and then chooses the date on the web control calendar as shown below:
Macro RO Sales VISTA - Current
Best Regards,
Philip
While choosing date on a web control calendar, the QM program chooses the first date found on the calendar.
That is if the calendar is showing December 2016 dates, there would be November 2016 last week dates also showing up.
If the program has to choose today's date (29 December 2016), it chooses the first '29' on the calendar, which is 29 November 2016.
How to make the program understand to choose 29th December 2016 instead.
Right now the program first chooses the date from Excel and obtains just the day as below:
Macro RO Sales VISTA - Current
,ARRAY(str) varDate
,es.CellsToArray(varDate "sel")
,str vDate=varDate
,str e5.left(vDate 2)
...and then chooses the date on the web control calendar as shown below:
Macro RO Sales VISTA - Current
Best Regards,
Philip
Best Regards,
Philip
Philip