Whilst I have you, If I may be so bold, may I ask why the following does not work.
a1 is a date and date formatted.
pm.activesheet.Range(a1).Value = pm.activesheet.Range(a1).Value +1
to simply add one day.
Search found 49 matches
- Fri Nov 29, 2019 3:44 pm
- Forum: BasicMaker 2018 for Windows
- Topic: Text(a1, "mmm") not in Basicmaker
- Replies: 6
- Views: 7411
- Fri Nov 29, 2019 2:10 pm
- Forum: BasicMaker 2018 for Windows
- Topic: Text(a1, "mmm") not in Basicmaker
- Replies: 6
- Views: 7411
Re: Text(a1, "mmm") not in Basicmaker
Thank you for your useful guidance martin-k. I am actually surprised, in VBA (which I know is not Basicmaker) the following is the full item... EntryMonth = WorksheetFunction.Text(pm.activesheet.Range("LastUpdate"), "mmm") which I guess means you do not have the equivalent of &qu...
- Fri Nov 29, 2019 11:29 am
- Forum: BasicMaker 2018 for Windows
- Topic: Text(a1, "mmm") not in Basicmaker
- Replies: 6
- Views: 7411
Text(a1, "mmm") not in Basicmaker
Text(a1, "mmm") in a cell correctly converts the date's month 11 to Nov.
EntryMonth = pm.activesheet.Text(pm.activesheet.Range("LastUpdate").Value, "mmm")
results in...
Object doesn't support this property or method
Have I done wrong or is it not supported?
EntryMonth = pm.activesheet.Text(pm.activesheet.Range("LastUpdate").Value, "mmm")
results in...
Object doesn't support this property or method
Have I done wrong or is it not supported?
- Fri Nov 29, 2019 10:38 am
- Forum: BasicMaker 2018 for Windows
- Topic: Date +1 issue
- Replies: 0
- Views: 97837
Date +1 issue
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...