Search found 1509 matches
- Thursday 28th March 2024 5:48pm
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
Re: [Solved - sort of] Get the Previous Sunday from a Date
Try it and see
- Wednesday 27th March 2024 9:17pm
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
- Wednesday 27th March 2024 9:36am
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
Re: [Solved] Get the Previous Sunday from a Date
Okay so i had a real proper read of your first post to see what the initial goal was again. You want to get from Sunday to Monday of a previous week from a given date. So get the previous Sunday , then the Monday before that... So you want something like this... Public Sub Button1_Click() Dim d As D...
- Wednesday 27th March 2024 8:45am
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
Re: [Solved] Get the Previous Sunday from a Date
Sigh
Not sure what you could not get your head around or why after asking 3 different questions that all got answered you did something completely different? i guess that's your prerogative.
Not sure what you could not get your head around or why after asking 3 different questions that all got answered you did something completely different? i guess that's your prerogative.
- Wednesday 27th March 2024 3:55am
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
Re: Get the Previous Sunday from a Date
I'm not sure what you mean by Hover over them?
Gambas will just display the date object as it is.
If they are using Date objects not Strings then just use Format where you need it formatted
sDisplayString = Format(dtStartDate,"dddd dd/mm/yyyy")
Gambas will just display the date object as it is.
If they are using Date objects not Strings then just use Format where you need it formatted
sDisplayString = Format(dtStartDate,"dddd dd/mm/yyyy")
- Wednesday 27th March 2024 2:11am
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
Re: Get the Previous Sunday from a Date
That cannot be true you make D a string object not a Date object. Then you make the string and return it... D = "01/" & Format(MonthName, "00") & "/" & Year Return D D will begin with 01/ . just like you made it Unless somewhere else along the line you are u...
- Tuesday 26th March 2024 1:17am
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
Re: Get the Previous Sunday from a Date
So i spent a whole minute writing this. (thanks to the clues given by the other Bruce :) ) Public Sub Button1_Click() Debug GetLastMonthDay(Now) Debug Format(GetLastMonthDay(Now), "dddd dd mmm") End Public Sub GetLastMonthDay(hDate As Date) As Date Dim d As Date d = DateAdd(hDate, gb.Day, ...
- Monday 25th March 2024 2:52am
- Forum: General
- Topic: [Solved - sort of] Get the Previous Sunday from a Date
- Replies: 16
- Views: 314
Re: Get the Previous Sunday from a Date
You cannot use a Date object like that by just adding/subtracting integers from it. You must use DateAdd() https://gambaswiki.org/wiki/lang/dateadd DateAdd() minus 1 week EDIT: sorry i had the gb.Week/gb.Day and the values round the wrong way. Private Function GetPreviousWeekDayDate(inputDate As Dat...
- Monday 25th March 2024 2:48am
- Forum: General
- Topic: Control + Shift + F
- Replies: 1
- Views: 80
Re: Control + Shift + F
It's now Ctrl+Shift+T
- Saturday 23rd March 2024 3:57am
- Forum: General
- Topic: Gambas Closing - Error Message
- Replies: 8
- Views: 444
Re: Gambas Closing - Error Message
sorry to take so long to reply but we were having a serious discussion about this problem. We do have the latest gambas3 from the gambas ppa. We tried the exec=gambas3 but it gave us nothing except the right click menu on the icon chnaged. Our small group has decided that there is something realy w...