So, I am at wits end on this question. I have a date picker in a writer document/form. I can read the chosen date easily enough (01/03/18). I can then break it down into a comma separated format easily enough (2018,01,03). Now the funk happens. When I try DateSerial() function it says no way - invalid function call. As overview, DateSerial(2018,01,03) works properly but a string created using Left, Mid, Right will not work?
today = ThisComponent.Drawpage.Forms.getByName("Form").getByName("dteDatePick").tex NewString= "20" + right(today,2) + "," NewString = NewString + left(today,2)+ "," NewString = NewString + mid(today,4,2) Print trim(NewString) 'gives the correct response MsgBox DateSerial(NewString) 'gives invalid procedure call