https://bz.apache.org/ooo/show_bug.cgi?id=109652
mroe <mroe.nos...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #10 from mroe <mroe.nos...@gmx.net> ---
(In reply to D Denny from comment #9)
> insertText(chr(9) + "Scheduled" + chr(9) + columnScheduled + chr(9) +
> "Ultimate budget payment due" + chr(9) + chr(9) +
> CDateFromISO(columnFinalBudget))
> fails with
> ACTION NOT SUPPORTED INVALID PROCEDURE CALL
How is columnFinalBudget defined? Where you get it from?
Nobody have posted a working sample macro or better a document with an embedded
macro to show the problem, what is expected and what is get.
And nobody says which LOCALE setting is used!
Sub Main
DateTest_mr( "2021-10-11" )
End Sub
Sub DateTest_mr( s As String )
InPutBox( "Date Conversion", "Result:", "String: " & s )
InPutBox( "Date Conversion", "Result:", "CDate( String ): " & CDate( s ) )
InPutBox( "Date Conversion", "Result:", "CDateToISO( String ): " & CDateToISO(
s ) )
InPutBox( "Date Conversion", "Result:", "CDateToISO( CDate( String ) ): " &
CDateToISO( CDate( s ) ) )
InPutBox( "Date Conversion", "Result:", "CDateFromISO( CDateToISO( CDate(
String ) ) ): " & CDateFromISO( CDateToISO( CDate( s ) ) ) )
End Sub
Result: (Locale: English (UK) )
But remember: This shows only the String representations!
String: 2021-10-11
CDate( String ): 11/10/2021
CDateToISO( String ): 20211011
CDateToISO( CDate( String ) ): 20211011
CDateFromISO( CDateToISO( CDate( String ) ) ): 11/10/2021
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
