Search the Community
Showing results for tags 'dates'.
I forgot an important and needed aspect of my code. I need to be able to check for people who work every other week. Is it possible to write the dates that they work (every other week) between two date ranges? Example: Bob Smith has a Start date of 8-26-2018 (that is the date he is hired) And He stops working on 12-12-18 (that's the day he goes on vacation or whatever) However his work shift is every other Saturday from 7:30 AM to 6:00 Pm. I need to calculate every other Saturday between 8-26-18 and 12-12-18 (is this clear?) here is the code I have so far. I am just missing
Is it possible to use Autoit to find every Monday within a date range? An example would be I want to find every Monday between 1/9/19 through 4/9/19. Then Autoit would give me all the dates on which Monday lands between those two dates. Sorry but I don't have any code so far. I was wondering if it was even possible. I read the help file and I didn't see a function that could do that.
This is an easy way to get the number of days between today and any future date without having to acount for Hours, Minutes, and Seconds. #include <Date.au3> Func ShowDays($FutureDate) $iDaysDiff = _DateDiff('D', _NowCalcDate(), $FutureDate) If $iDaysDiff < 1 Then Return 0 ;Insure only positive return Return $iDaysDiff EndFunc ;==GoPR MsgBox(0, '', ShowDays("2017/07/31")) I use it to know how many days till I go on my next vacation. Maybe one of you can find a use for it.
Hi I ask for generic advice on what field format is best to use to store dates in a database (SQLite). if is a better choice to stored separately year, month and day into 3 separate fields or use one field for a complete date-time group? I have to store information of this kind: a person is assigned to a job for a certain day (one day only) or also a person is assigned to a job from a day to another day (a range of days) then i have to query the database for a certain day so to know who is working to a certain job in a specific day. Well, in the case of ranges of days