I have SAS 8.2 running under Windows XP home edition. But when I open up Enterprise miner it does not display correctly, therfore is there a compatability issue.
I have created the folloing if then else statement in a formula field
if status = "86" then "Live" else
if status = "87" then "Live" else
if status = "88" then "Live" else
if status = "89" then "Live" else
if status = "90" then "Live" else
if status = "91" then "Archive" else
if status = "97"...
I have created a report which just contains a Cross-tab. The problem is that the values are OK, and the column totals are OK, its just the row total that are not correct.
Any suggestions would be appreciated.
I am trying to add an authorisation field to the bottom of an Access Form. As the database is to be used for authorising Purchase Orders within the Finance department, I need to add some sort of 'Electronic Signature' to the authorisation field. This will used to track and audit who has signed...
I am running a query against an Oracle database that stores dates in the following format 23SEP2004:00:00:00. When I try to select records for an specific day, in a where clause I dont get the correct results. I am using the Datepart function to get rid of the Hr:mm:ss.
Any ideas
I need to select records based on the follwoing criteria
Job type not equal to cancelled and
Mailing date between X and Y and
Completion date is null
or
Job type not equal to cancelled and
Calldate1 between X and Y and
Completion date is null
or
Job type not equal to cancelled and...
I have a Date field which is displayed as a series of numbers i.e. 200203051200310, and I want to convert this to a date field.
Attached is the formula that I have been using to convert the number to a date.
CDate(Mid([dbo_options]![LAST_UPDATE_MINI],7,2) & "/" &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.