-
case when field is blank write something else display value
Have a field settlementID, I'm wanting to display when there isn't a value for that row to show pending else show the settlement id something like when settlementID is blank then 'Pend…1 -
date range question
I have a field called 'hire date formatted' as such: DATE_FORMAT(CONVERT_TZ(`hireDate`, 'America/Denver', 'UTC'),'%m/%d/%y') I have to do this as 'hiredat…1 -
Re: compare field with current date
I got it...just as you suggested...thanks1 -
Re: Join twice on a different column
that worked...thanks for your help1 -
Re: date range question
looks like that worked...thanks1
