I am running CR10 and using a SQL Server Database. I have this formula so far.
if time({Cases.CreateDate}) <= ctime(9,0,0) then
cdatetime(year({Cases.CreateDate}), month({Cases.CreateDate}),day({Cases.CreateDate}),9,0,0)
else
{Cases.CreateDate}
What I want to incorporate into this formula is that if the CreateDate happens to fall on a weekend, I want it to also change the date to the next Monday. Is this possible?
if time({Cases.CreateDate}) <= ctime(9,0,0) then
cdatetime(year({Cases.CreateDate}), month({Cases.CreateDate}),day({Cases.CreateDate}),9,0,0)
else
{Cases.CreateDate}
What I want to incorporate into this formula is that if the CreateDate happens to fall on a weekend, I want it to also change the date to the next Monday. Is this possible?