Day of week criteria in caseware idea3/18/2024 You can also use DateTime fields (which are not native to IDEA but can be stored as a character field). Notes: The functions returns both positive and negative number depending on how the dates are set-up. Week that has at least four days in the new year Parameterįirst week of year specified in system settings WeekOfYear - This is optional and allows you to decide how the first week of the year is calculated. Parameterįirst day of week specified in system settings Parameterĭate1 - The first date/time value you want to use in the calculation.ĭate2 - The second ate/time value you want to use in the calculation.ĭayOfWeek - This is optional and allows you to decide on what day the week starts on. In the script below I used constants to better define them. Depending on the interval the DateDiff() well return the number of units in the Interval. Interval - There are 10 different types of intervals. Syntax: DateDiff(Interval as String, Date1 as Date, Date2 as Date, Optional DayOfWeek, Optional WeekOfYear) as Long
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |