The Conservative Cave
The Help Desk => Computer Related Discussions & Questions => Topic started by: SSG Snuggle Bunny on April 03, 2013, 11:30:21 AM
-
I've read a ton of manuals and my head is swimming. I can't even find the words I need to nadin what I'm looking for.
I have 2 issues I need to take care of, the first playing into the second.
1) I have a DateDiff function that returns a value in years but I need to convert that value into a designated text string, i.e.
Value | String |
2 | Over 2 |
3 | Over 3 |
4 | Over 4 |
5 | Over 4 |
6 | Over 6 |
7 | Over 6 |
8 | Over 8 |
9 | Over 8 |
etc
2) using the text string as returned above I need to cross-index that with the employee's pay rate code to find their monthly salary.
I don't even know what to call these functions to properly google them. If anyone could at least get me that far I'd be grateful and promise not to switch-out your Coco Puffs for a bunny surprise.
-
Does this help at all? I realize you must have figured it out already, but here ya go anyway.
http://www.postgresql.org/docs/9.1/static/functions-datetime.html
I'm just cruising this area for a PowerPoint question. I haven't really used office docs for awhile - so I've forgotten everything I used to know. Good luck :cheersmate: