BretOsborne
Qrew Member
Joined 3 years ago
User Profile
User Widgets
Contributions
Duration Date/Time and Dates
I am trying to figure out a formula for duration. my problem is that one set of date is Date/Time, while the other is only Date. QC Date - Date/Time Start Date - Date The QC Date pulls from a relationship, so I don't think I can simply change the QC Date to "date" only because of the relationship. However, what I am trying to do is determine only the number of days between the two and exclude the "time" portion, if possible. I thought i was close with this formula, but it does not like the subtraction. DAYOFYEAR(TODATE([QC DATE CREATED]))-[DESIGN START DATE]) All i need it to do is pull the date and ignore the time stamp - QC date 11/22 - start date 11/20 = 2 days. Is this possible? I looked at other formula functions as well, but to no luck so far. Thanks! ------------------------------ Bret Osborne ------------------------------381Views0likes2CommentsRe: Color Coding Dates
Right, but i guess that is not what i am trying to get it to do. Whenever each date is populated i am looking for it to change the color to something different, so i can "see" visably the stage of the project. So as each date does get populated it would clear the previous color and change to the most recent color instead. ------------------------------ Bret Osborne ------------------------------16Views0likes1CommentRe: Color Coding Dates
no, i am not looking to color individual cells, the whole row is fine. I just can't figure out what the formula should be to make this happen. so something like this: if to QC "date populate" = yellow if returned from QC "date populate" = blue if to QC 2 "date populate" = green If returned from QC 2nd "date populated = Red something like that? I had If( [To QC 1]<(Today()+Days(1)), "yellow", [Returned QC 1]>(Today()+Days(1)), "blue") but when i got to the second line, is does not read the 2nd next statement. I also tried If( not IsNull([To QC 1]),"yellow", If( not IsNull([returned QC 1]),"blue")) but it only reads the "TO QC 1" statement, ignoring the first line. I know i am likely missing something basic, but again newbie! :) ------------------------------ Bret Osborne ------------------------------28Views0likes3CommentsColor Coding Dates
I am newer to QB, but have found formulas to be a challenge so far. I am trying to do simple color coding for dates, for example i have 4 columns of dates, that will be populated through the project. As each progression of the project is complete i would like to have that date color coded to show the "stage". so column A,B,C,D, then i will select colors for each column. If no dates are populated, then it would not be color coded. I believe this should be some type of IF statement, but not sure how to formulate it. Thank you for your help! ------------------------------ Bret Osborne ------------------------------78Views0likes5Comments