Search results for query: *

Perfect. Thanks so much, strongm! Slight modification to the DateSerial function for my needs. Here's the final formula for anyone else that may someday be looking at this ... MondayDate: DateAdd("ww",[My_Table]![Week Number]-1,DateSerial(Year([date]),1,1)) * Putting the Year function...

Good morning, Experts. Hopefully there's an easy way to do this. I'm trying to create an expression in builder. I have a 'Week Number' field (which is just what it sounds like, the week number of the year for that record). I'd like to get the Monday date for that week number. For example: if...

Combo - never even heard of that formula. Does exactly what I needed. Thanks again, sir.

Perfect! thanx, Skip!

Good afternoon, Experts. I'm need a formula to calculate COL-C. If both A and B have data, then I need the result (in COL-C) to show both fields separated by a / character. If only one of A or B have data, then I need the result (in COL-C) to show just the one field (no / character). I'm very...

Perfect! Exactly what I was looking for. Thanks, Andrzejek!

Hello all, I think what I'm trying to do is pretty straight forward, but I'm no excel expert (sadly). I have three columns, I want the average of the contents, depending on how many columns are greater than zero. So, if two of the three cells are greater than 0, I want to divide by 2. If only...

You're right, that is precisely how the 'date' function returns the date. I'll need to replace the \ with - symbols. I will fool around a bit using your previous posts. Thanks again. -TS

Thanks for the replies, guys. Forgive me, but I really am a novice with DOS commands at this point. So the line I got from another site ... copy TEST.txt TEST-%DATE%.txt is not even close? Keeping in mind, i just need a datestamp on the target file name, the format doesn't really matter. -TS

Hello experts - I'm hoping this is a simple request, I haven't had to use too much DOS in recent years so I'm probably forgetting something common. I need to do a basic file copy from one location to another, but I need to target file to get a date extension so that it doesn't overwrite files...

Hey lbass. Long time no see. Hope you are well. No the date ranges refer to a specific time allowed to do certain work activities in areas where there are endangered species present. They start/end at all sorts of points of any given month.

It really doesn't have to be in excel if I could get the gantt chart to do what I need. I would wind up exporting it to PDF format. I'm not sure CR can't do what I need, I just can't seem to find any useful documentation or examples of how to create what I'm looking for. I have no experience...

Yes, those two fields are not shown on the pic, the START_DATE for that row is 08/01/2020 12:00:00AM, the END_DATE is 02/28/2020 12:00:00AM. Note how it 'wraps' around the year ... so really, that end date would be 2/28/21 ... but we only care about the day and month. The people loading the data...

Ideally, I'd like a Gantt chart to look like the attached. Two records shown. All 12 months across the top. Then one line per record going down (no grouping needed here). With the chart next to each line. The data consists of the SPECIES_NAME (string), DATE_RANGE (string), START_DATE...

Thanks, Skip. I'm really just trying to save the formatting that I'm doing in the report. I lose a little of it when I export using the 'workbook data only' option. Exporting to a CSV or text file would pose the same problem. I think I'm just going to have to deal with it. Curious as to why...

Hi experts, I'm trying to export a crystal report (using CR2013) using the 'Microsoft Excel (97-2003)' option. Unfortunately, I have a column for every day of the year, and a couple more. The export stops on column 256 (IV). This is because crystal automatically exports to an XLS file, instead...

Forget it ... forgot about the 1000 record limit. Need a command after all. Thanx anyway! -TS

Hello Experts - Haven't used a simple dynamic cascading parameter in a long time. No commands or anything complicated here. Just one table, two fields. Field A (we'll use State for example) drop box should display 50 states then Field B (City) drop box should display all cities for the...

I think I've got it. I knocked the select in my command to just those two fields that I want in the parameters, plus a municipality code ... THEN, I linked the command back to the initial SERVICE_VW via the district and municpality code from the command ... now, I have the parameters working...

That's interesting. There's no way the district/muniname combo will ever be more than 1000. Here's what my command sql looks like ... SELECT distinct("MCD_BOUNDARY_V"."MUNINAME"),"SERVICE_VW"."DISTRICTNAME", "SERVICE_VW"."MCD", "MCD_BOUNDARY_V"."MUNNUMBER", "SERVICE_VW"."OBJECTID" FROM...