Recent content by TomSalvato

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