PS Query & SQL

Do you ever need to perform some sort of calculation in PS Query that you rarely encounter, and just can’t figure out how?  For example, how do you calculate days before or after a system-defined date?  How can you calculate how many days are between two system-defined dates?  Can you then convert that to weeks?

How do you get rid of unwanted characters or hard returns in a field value, return a value even if one doesn’t exist, and how about that CLOB error?

Here are a few tips on some possibly uncommon PS Query expressions.  These examples, while specific to student records data, are applicable in other areas as well.