In Planmaker a cell containing a date can simply have 1 added to get the next full date.
a1 = 20/11/2019 , b1 =a1 + 1 shows 21/11/2019 as it should.
With Basicmaker I have the following line...
MsgBox pm.activesheet.Range("a1").Value +1
Using the above a1 the MsgBox show 21 not a full date.
I did the test because the original intention was to update a1 by 1 and it failed
pm.activesheet.Range("a1").Value = pm.activesheet.Range("a1").Value +1
[Edit] The cell then contains 20/01/1900 instead of 21/11/2019 then subsequent loops adding 1 leaves the date at 20/01/1900
The cell is formatted as date as shown for a1 above
What is wrong please?
Date +1 issue
Questions and answers about BasicMaker 2018 for Windows
Post Reply
1 post
• Page 1 of 1
Return to “BasicMaker 2018 for Windows”
Jump to
- Beta: SoftMaker Office 2021 for Android
- ↳ BETA: SoftMaker Office 2021 for Android (general)
- ↳ BETA: TextMaker 2021 for Android
- ↳ BETA: PlanMaker 2021 for Android
- ↳ BETA: Presentations 2021 for Android
- Office
- ↳ SoftMaker Office 2021 for Windows
- ↳ SoftMaker Office 2021 for Windows (General)
- ↳ TextMaker 2021 for Windows
- ↳ PlanMaker 2021 for Windows
- ↳ Presentations 2021 for Windows
- ↳ BasicMaker 2021 for Windows
- ↳ SoftMaker Office 2021 for Mac
- ↳ SoftMaker Office 2021 for Mac (General)
- ↳ TextMaker 2021 for Mac
- ↳ PlanMaker 2021 for Mac
- ↳ Presentations 2021 for Mac
- ↳ SoftMaker Office 2021 for Linux
- ↳ SoftMaker Office 2021 for Linux (General)
- ↳ TextMaker 2021 for Linux
- ↳ PlanMaker 2021 for Linux
- ↳ Presentations 2021 for Linux
- ↳ SoftMaker Office 2018 for Windows
- ↳ SoftMaker Office 2018 for Windows (General)
- ↳ TextMaker 2018 for Windows
- ↳ PlanMaker 2018 for Windows
- ↳ Presentations 2018 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2018 for Windows
- ↳ SoftMaker Office 2018 for Mac
- ↳ SoftMaker Office 2018 for Mac (General)
- ↳ TextMaker 2018 for Mac
- ↳ PlanMaker 2018 for Mac
- ↳ Presentations 2018 for Mac
- ↳ SoftMaker Office 2018 for Linux
- ↳ SoftMaker Office 2018 for Linux (General)
- ↳ TextMaker 2018 for Linux
- ↳ PlanMaker 2018 for Linux
- ↳ Presentations 2018 for Linux
- ↳ SoftMaker Office HD for Android
- ↳ SoftMaker Office HD for Android (General)
- ↳ TextMaker HD
- ↳ PlanMaker HD
- ↳ Presentations HD
- ↳ FreeOffice 2018 for Windows
- ↳ SoftMaker FreeOffice 2018 for Windows (General)
- ↳ FreeOffice TextMaker 2018 for Windows
- ↳ FreeOffice PlanMaker 2018 for Windows
- ↳ FreeOffice Presentations 2018 for Windows
- ↳ FreeOffice 2018 for Mac
- ↳ SoftMaker FreeOffice 2018 for Mac (General)
- ↳ FreeOffice TextMaker 2018 for Mac
- ↳ FreeOffice PlanMaker 2018 for Mac
- ↳ FreeOffice Presentations 2018 for Mac
- ↳ FreeOffice 2018 for Linux
- ↳ FreeOffice 2018 for Linux (General)
- ↳ FreeOffice TextMaker 2018 for Linux
- ↳ FreeOffice PlanMaker 2018 for Linux
- ↳ FreeOffice Presentations 2018 for Linux
- ↳ FlexiPDF 2019 for Windows
- ↳ FreePDF for Windows
- ↳ FreePDF for Windows
- Miscellaneous
- ↳ SoftMaker Fonts
- ↳ Water Cooler