Calculate Quarterly Date - IIF or DateAdd?

[smedvid]

I have a need to compute the nearest Quarterly Date (forward) and the brain is not at 100% today I guess.

I thought this would work, but when I try to update - I get an error.

UPDATE tblData SET tblData.CDate_Qtr = IIf(Month([cdate])<=3,'3',IIf(Month([cdate])>3 And Month([cdate])<=6,'6',IIf(Month([cdate])>6 And Month([cdate])<=9,'9',IIf(Month([cdate])>9 And Month([cdate])<=12,'12',Month([cdate])))))+'/01/'+Year([cdate]);

' CDate_Qtr is a date/time field as is cdate.

Perhaps there is a DateAdd() that I could use?

Thanks in Advance,


Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[smedvid]

Too much T-SQL and P/L SQL lately...

]))))) & '/01/' & Year([cdate]);

Should do the trick I think...


Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[SkipVought]

hi,

QtrDate: DateSerial(YEAR([YourDate]),INT((MONTH([YourDate])-1)/3)*3+1,1)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}