RE: Using DateDiff to calculate days before a Birthday

SSC Guru

Points: 1003857

September 12, 2010 at 9:04 pm

#1219813

kenkob (9/12/2010)
Jeff,
After a little trouble I have got it working. When I attempted to use it as a SqlCe CommandText string surrounded by inverted commas, I was always getting an error. However, by adding the code copied directly from the web forum page into a multiline textbox it worked fine.
Thank you very much for your help.

Thanks for the feedback, Ken. I usually end up pasting the copy from the forum into MS Word which "fixes" a lot of stuff from forums and then copy/paste to my application. Almost the same thing as you did.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)