Recent content by goldfishhh

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