Search results for query: *

I figured as much. The problem with the database is that it is read-only on my end, but I am the person that is asked to report off of it, though I am not allowed to make any changes without request of the vendor. I figured I was stuck. Thanks for replying.

I have a database that, for every single date within, breaks out century, year, month and day. So, in the century field in, say, the orders table, today would be 20, the year would be 11, the month would be 1 and the day would be 21. Thus, whenever I have to report on date ranges, I first have...

Thanks.

I have a field that shows the date as such: 20100901 I have written this formula to build the date: date(tonumber(left(totext({date}),4)),tonumber(mid(totext({date}),5,2)),tonumber(right(totext({date}),2))) I use the formula in the select expert to pull @Date in LastFullMonth. When I run...

Is something like this possible? Basically, every formula either returns a 1 or a 0, but it only reads down to "Cable/Internet" and then everything else comes as a blank value. SELECT {@CABLE} CASE 1 : SELECT {@INTERNET} CASE 1 : SELECT {@PHONE} CASE 1: "THREE PLAY"...

Well, that was easy. Thx.

I have a table where the "Address" field can be typed in either uppercase or lowercase or a mixture of the two. Thus, we mail information to people at for instance: 3021 TaylOR DRive I thought I could write a formula called UAddress: uppercase(Address) And then another formula called Match...

Looks like it works. Thanks so much.

I have this formula. It's pretty straight forward, but Crystal is telling me that I need a closed parenthesis and is highlighting the word "else" in line nine. I know one doesn't need to go there. I'm thinking I have a syntax error. If you need any more info about the fields, let me know...

I have a table with four different columns that would figure date. They are all numerical... Century (20) Year (9) Month (1) Day (19) I use the following date formula NumberVar input := (1000000*{Century})+(10000*{Year})+(100*{Month})+({Day}); If input < 19720101 then Date (1972, 01, 01)...

Thanks, it was missing a close parenthesis or two, but it worked perfectly...

My current formula works, but it doesn't include the time at all. I need the time included in the formula and to make it a date/time field.

I have a table with five different columns that would figure date and time. They are all numerical... Century (20) Year (8) Month (6) Day (3) Time (1350) I need to write a formula to get them all into one date/time field. What is in the parenthesis is just an example of what one field in...

This is likely pretty simple, but I am a SQL newbie. I've been working around it for quite some time, but if I want things to be automatic, I need to figure little things like this out... If I type this: SELECT CAST((CENTURY*1000000+YEAR*10000+MONTH*100+DAY) AS VARCHAR(8)) AS DATE, ACCOUNT...

If there is a date in the database I'm using, it is broken into four columns for Century, Year, Month and Day. I have been able to write a formula to put this into a date format in Crystal, but I need to write a SELECT statement in SQL to turn the four columns into a readable and usable date...

I guess I am not being clear. I want to know how many accounts (distinct count) as well as how many instances of a service (count) had a certain service on each day of a given date range. I have accomplished this by writing 31 formulas (one for each day of the current month), and making a...

Account Svc Start End 123 BAS 20080101 20080113 123 EBA 20080101 20080113 124 BAS 20080103 124 EBA 20080102 20080115 124 EBA 20080103 20080115 125 BAS 20071206 20071225 125 BAS 20080101 125 EBA...

I have a table that includes these four columns: Account # Service Code Start Date End Date I have been able to see how many accounts have a certain service obviously quite easily by simply using the select expert and saying start date < x <= end date. Is there any way to group a report for...

One is a server side database on an AS/400 that holds our billing system. It contains the numerical fields. If I attempt to SQL query this database, it crashes the billing system. :) The table is subsmstr and the field is suacct. SUACCT 1000000 1000008 1000012 The second is a PostgreSQL...

I have two databases. One keeps the account number as a numerical field (1234567). The other keeps it as text, with a leading zero (01234567). Is there any way to link these two together?