Search results for query: *

Will do thanks.

I have 9i database that was just built and when I login through OEM and click on the database folder none of my databases show up. I believe I have to use NET8 Config assistant to recreate the tnsnames.ora but not quite sure. Any help would be appreciated.

Thanks for clearing that up.

What about logging into svrmgrl because I was able to do that and connect as sysdba with a password, but when I used that same password for sqlplus, it didnt work. This whole issue came about because we thought there was a particular user in the database. We have come to find out that no user...

I am using a windows 2000 box and I dont remember what my system password is. I want to log in as sysdba to change it but there is just one problem. SQLPLUS prompts me for a password. How do I work around that? I know it has something to do with the remote_login_password file and the orapaswd...

How do you find out if you have reached your max when it comes to expressions or columns in a table??

It worked!!! Thank you very much. I was starting to pull my hair out over here.

I used the cursor and dropped it in the formula, still getting errors.

this is what it looks like: HPD_HD.Date_Closed when I drop it into my edtitor. if isnull({HPD_HD.Date_Closed})then dateserial(year({?DateRange}), month(?DateRange)+1,1)-1 else {HPD_HD.Date_Closed} This is what my actual text looks like in my editor.

I am sorry... you might laugh at this, but I am just not understanding what your asking me to do... maybe its because I am a little frustrated with this....LOL.. I am not a big fan of programming.

I am using Date_Closed:Date Time field

actual formula: if isnull({Table.Date_Closed})then dateserial(year({?DateRange}), month(?DateRange)+1,1)-1 else {table.Date_Closed} This is what I have in my editor.

if isnull({table.Date_Closed}) then dateserial(year({?MyDateClosed}),month(?MyDateClosed)+1,1)-1 else {table.Date_Closed} Can you put some type of variables in the formula for me so I can get a better idea. And what do you mean by this: Of course you need to substitute your actual date field...

yes I checked the datatype. It is DateTime datatype

lbass, It isnt working. Could you please show me how the formula is supposed to look.

dgillz, I tried the formula SV suggested... still getting the same error. dateserial(year({?MyDateClosed})<------ the MyDateClosed is highlighted Blue and tells me I need a date there when I save the formula.

dateserial(year({?MyDateClosed}), On this part of the formula, it tells me I need a date??

if isnull({table.Date_Closed}) then dateserial(year(currentdate),month(currentdate)+1,1)-1 else {table.Date_Closed} This is the formula I am using. I have parameter that prompts for date ranges. In my prompt I use 1-Aug-07 to 31-Aug-07. When the report comes back the Date_Closed shows the...

For some reason when I run the report for the month of August because I have it set up where my report prompts me for dates(1-AUG-07 - 31-Aug-07). For my null values it will give me a date of 9/30/07. I thought it would give me the date of 8/31/07??

What I am asking is with the formula you gave me, how do I get it to show 8/31/07 for the null values for the Date_Closed field and if I run this same report for September to show 9/30/07. I hope that clears it up.