... // check if end date is specified and if it is then add to this row
v_EndDate = null;
v_EndDateValue = ZDK.Page.getField('Actual_Finish_Date').getValue();
if (v_EndDateValue !== null) ...
... DateDiff( startdate, enddate, units="d" ) {
If units NOT IN s,sec,second,seconds,m,min,minute,minutes,h,hour,hours,d,day,days
units := "d" ; default to days
...
... where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date:
-- Assuming EndDate is optional (can ...
... @StartDate DATETIME, @EndDate DATETIME
--First day of current month
SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
--First day to display on calendar
SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate)
--Last ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.