flicksllka.blogg.se

You can find this value by setting the searchvalue for the weeknumberfield in Findmode to WeekOfYear(statusCurrentDate). So you have to search for the value 20 (weekOfYear = 20) in the weeknumberfield. When you set the weeknumberfield to weeknumber = yourdatefield, all those values from this week will be the same in the weeknumberfield (which is, I think week 20) So you have to search on the weeknumberfield, which have the value of 'this weeknumber'. You want to find the 'currentWeeknumber' value from a date field. This will generate a number, which is the week of the year the date falls in. Weeknumber = calc = WeekOfYear(yourDateField) So first you need a field weeknumber = date. To have a number of the week from a datefield, you have to enter that value in a weeknumberfield. JW RE: How to create weekly report Sleighbor (MIS) 17 May 05 10:31

Tweak the steps to go to the appropriate layout when you have 1 or more or none records. Here you can insert some other steps, like trigger the possible errorcode and actions to do if. Year(zc_creationDate) = (Year(Status( CurrentDate)) - 1) "Year before" Ī script Find that looks in the list of valid dates, and finds the records that match the selected dat or period. Year(zc_creationDate) = Year(Status( CurrentDate)) "Current year" Month(zc_creationDate) = Month(Status( CurrentDate) - 7) and Year(zc_creationDate) = Year(Status( CurrentDate)) "Previous month" " " Month(zc_creationDate) = Month(Status( CurrentDate)) and Year(zc_creationDate) = Year(Status( CurrentDate)) "Actual month"

WeekofYear(zc_creationDate) = WeekofYear(Status( CurrentDate) - 7) and Year(zc_creationDate) = Year(Status( CurrentDate)) "Week before" " " WeekofYear(zc_creationDate) = WeekofYear(Status( CurrentDate)) and Year(zc_creationDate) = Year(Status( CurrentDate)) "This week" Zc_creationDate = Status( CurrentDate) - 2 "Last " & DayName(zc_creationDate) " " Zc_creationDate = Status( CurrentDate) - 1 "Yesterday" Zc_creationDate = Status( CurrentDate) "Today" Zc_creationDate_cti - calculation - text = Tweak your script to show one record if one record is found, what to do if no records, what to do if multiple records etc.Īn other way to go, if you want to find 'dates' is a calculation field with a script, something along these lines (if you have a zc_creationDate = date field): If you have a 'weeknumberfield' = WeekOfYear(date), you can search on this field.