Recent content by Cort

That worked great. Thanks. Yeah DatePart can come in handy here also.

This is the formula I thought should work but it's giving me only true/false for some reason. if {date_created} > (currentdate - 6) then {date_created} = DateTime (2004, 08, 08, 00, 00, 00) else {date_created} = {date_created}

CR 9.0 I'm looking to show dates in a xtab. What I'd like to do is have a formula that if [date.created] is within the last 7 days then show the data by individual day but if the [date.created] is older than 7 days then clump it into a single column. The output would look something like...

Could be me :) www.thewanderers.us if that's the Cort your thinking of.

Never mind. Figured it out.

A bump just in case...

Word 97 This is the code I'm currently using: Private Sub UserForm_Initialize() Combobox3.ColumnCount = 1 'Load data into ComboBox Combobox3.List() = Array("", vbCr & vbCr & "yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda yadda ")...

Thanks everyone. There was an error in my original post from yesterday that I didn't see until now. Lyanch understood what I was looking for, thanks :). Was I was wanting was the MIN date in the default to be weektodatefromsunday and the MAX date in the default to be < currentdate I work...

I must have not communicated myself properly. The formulas work great. They get me exactly what I need which is a date range from the current Sunday to Midnight of the currentdate. Far Example: for today the date range would be June 27 through July 1st. What I would like to know is if...

Hello all. I'm sure this is a somewhat newbie question but I can lcoate anything in keyword search or the FAQ's. CR 9.0 I have a date range parameter used in my record selection and I want to use the results of a formula as the defaults for that range parameter. Is this possible? This is the...

Thanks for the reply something along the lines of {PAIDMONTH_tmpMonth} was exactly what I was looking for. Figured that it could be done but suppose not. Thanks again

Can you help me make this formula more elegant and efficient. I know it can be done but I haven't been able to quite get variations other than this to work. CR 9.0: if Month(minimum(LastFullMonth)) = 1 then {PAIDMONTH} else if Month(minimum(LastFullMonth)) = 2 then {PAIDMONTH_2} else if...

Yup. It works in SQL. As to why it does not work in CR I'm not completly clear on. The solution supposedly is either a manual X-Tab (which I hate to make, far too much upkeep) or a stored procedure (which I'm very unfamiliar with) /sigh

Correct that will work. But take your selection criteria and specify that you only want contracts assigned within a specific date parameter it will then return the names with a count of the valid dates but will drop those names without a valid date.

Correct it will work like that as long as you do not specify any criteria from Table 2. Once you try to specify any criteria from Table 2 (such as when it was assigned) it will drop the Reps from Table 1 who do not have an assignment.