Search the Community
Showing results for tags 'calc'.
I decided to enhance the functionality of the OOo COM UDF found >here and >here. Thanks to Leagnus and Andy G for providing the initial functions and framework. This UDF includes the following working functions: _OOoCalc_BookNew _OOoCalc_BookOpen _OOoCalc_BookAttach _OOoCalc_BookSave _OOoCalc_BookSaveAs _OOoCalc_BookClose _OOoCalc_WriteCell _OOoCalc_WriteFormula _OOoCalc_WriteFromArray _OOoCalc_HyperlinkInsert _OOoCalc_RangeMoveOrCopy _OOoCalc_RangeSort _OOoCalc_RangeClearContents _OOoCalc_CreateBorders _OOoCalc_NumberFormat _OOoCalc_ReadCell _O
I want to check if the system time has added to 10minutes so I used this: $sNewDate = _DateAdd('n', 15, _NowCalc()) $sNewDate2 = _DateAdd('n', 0, _NowCalc()) ConsoleWrite("current time now: " & $sNewDate2) ConsoleWrite("time after 15minutes: " & $sNewDate)this print me out .... 2016/01/12 10:04:55 and .... 2016/01/12 10:14:55 and but how can I make a statement like if $sNewDate2 has + 15minutes so I can do something after the check.