Search results for query: *

Well, well, well... now there is a feature in Crystal I haven't ever used. Works like a charm!

If you knew where in the big mess of text your date lived, you could use MID() and Dateserial() and Month(), day(), year. dateserial(year(mid({field.bigtextmess},5,2)),month(mid({field.bigtextmess},10,2)),day(mid({field.bigtextmess},14,2))) D-

Ok, I'm stumped. I'm grouping by week and want to get a sum for TD1OZ, TD2OZ and TD3OZ broken out by PreHH and PostHH. I'm just having a hard time wrapping my brain around how to sum these totals. I can sum for all of TD1OZ, but can't figure it out how to break it out. (then for extra credit...

*bangs head against wall* That did it!

Why on earth am I getting an extra day (Dec 31st)?? Too many ")"? HAVING (((ProdJobABEND.DATE)>DateAdd("m",-18,(Now()-(Day(Now())))) And (ProdJobABEND.DATE)<=Now()-Day(Now())));

DING DING DING! Thanks for the push in the right direction. After a bit of fiddling and data validation, here is what I came up with: //Small Timestamp Local Stringvar SmallFirstTime := totext(Mid ({ProdJobABEND.TIME},1,1)); Local Stringvar SmallSecondTime := totext(Mid...

I've been staring at this too long. Why am I getting this error with this formula: "Too many arguments have been given to this function." iif( Length ({ProdJobABEND.TIME})>10, time(5,5,5), (Time( (Mid ({ProdJobABEND.TIME},9,2)), (Mid...

Maybe a better way to ask, is there a way to show what hot fixes have been installed on my client? Is this contained within the HELP | ABOUT screen?

I'm having a slew of minor annoyances with CR XI and visited the tech support website. It appears there are a few HotFixes which will take care of virtually everything. I have downloaded the Release 1 hot fix and release 2 hot fix (and being a bad user - installed them both). I'm still having...

Ahhhhhhhhhhhhhhhhhhhhh There ya go! I completely forgot that you couldn't have 2 tables pointing to the same one.

Table 1: Days - Date Table 2: System Name - Text Table 3: Event Failure Date System Name Job Number Failure Job ID Table 4: Event Sucess Date System Name Job Number Success Job ID I'm linking: From Table 1 Date to Table 3 Event Failure Date (left outer join) From Table 1 Date to Table 4...

Will this do it: ShiftDateTime {your_datetimefield}, "UTC,000,UTC", "CST,480,CDT") Maybe?

I have a way to convert Epoch to CDT (If you want that formula, I'm happy to share), but now need to convert a CUT time and date stamp with our local time. In Chicago we observe Daylight savings. Help computer! http://en.wikipedia.org/wiki/Coordinated_Universal_Time

I have a dataset which has the dates a job has failed. In my report, I'm grouping by month. There are some months where I don't have any data, yet I want to display the date as a blank. How? The data looks like this: Jan Mar April July 1 10 12 4 I want it to look like...

Yea - I looked into it a bit further and it appears if I were to relate any tables, it would be a "many to many". I can have a single failed job fail multiple times. There is no way to distinguish which job took a certain period of time to open. Looks like I gotta attack it a different way...

Table 1: Job Name, Job down date (and a bunch more things) Table 2: Issue description, Issue enter date (and a bunch more things) The Job name in table 1 is somewhere within the Issue description of table 2. There can be text before and/or after the job name in the Issue Description of table...

I'm beating my head against the wall on this one. I want to run a report during a month and have the date range be "past 3 months". Help computer!

Sometimes the best things in life are dirty. Heh. Tis worked like a champ! You rock!

Unfortunately not. It is just a huge long string of text.

Ok, part 2. This is where it gets complicated. (sorta). Here is my output and all of this comes from one field (rather the output from the formula above): CONDITION: Response time is greater than 10.00 seconds DESCRIPTION: Response time was 22.31 seconds. --- LOCATION: chicago TIME: Tue Jun 10...