Recent content by celauritz

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...