Search results for query: *

Thank you! This was exactly what I needed. I even can use it for my other staff files! I understand the inbuilt functions much better than the macro. I will try to figure out the macro. Thank you! Lareya ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++...

Hi all, I have a staff file name which has the lastname,firstname in one column. I want to take all the names and regardless how long the names are in character, I want to have the lastname be four charachter, and the firstname in four charachters. thus: pierce,marta will be added to the H...

Okay, I was able to change the format to this: 03/01/1999 gave this: 01/01/1800 01-March-1991 13:23 gave this: 01-Jan-1800 7:30 I have noticed that my time fields that are zero'd out are actually datetime(1800,01,01,00,00,00) to get the no time & date Lareya...

hmm, when I put my cursor over the field it reads the field and has (date time) come up. However, when I use your field as you suggested the span midnight doesn't work. It acts like it really is just a time field? I rechecked my fields again. I went back into the format field and changed...

Just wanted to add that I changed the first line to check for time that spanned the midnight hour. numbervar timex :=IF {POST_CASE.LEAVE_PROC_ROOM_TIME} < {POST_CASE.ENTER_PROC_ROOM_TIME} THEN ((TIME ({POST_CASE.LEAVE_PROC_ROOM_TIME}) + 86400) - (TIME ({POST_CASE.ENTER_PROC_ROOM_TIME}))) /60...

You both are BEAUTIFUL people! thank you thank you! They both work, and plus I can learn from both examples! Lareya! ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Crystal XI; SQL database; MS Windows 2K; ORSOS/One Call Hospital Scheduling System v10.1.2...

I guess I am looking for is a formula that goes like this (quasi code) If the case is more than 30 minutes then 1 and if the case goes longer, break it up into 15 minute increments rounding up past 10 minutes. and it would show this level 30 1 15 4 or 30 -1 15 -4 or anything that...

Okay, the {POST_CASE.ENTER_PROC_ROOM_TIME} & {POST_CASE.LEAVE_PROC_ROOM_TIME} they are both date time fields that are formated to this 13:23 fields show this on a report 11:15 Room Time in (the words are my titles) 11:59 Room Time out thanks...

Can someone help me with a formula that will add some time up for me? {POST_CASE.ENTER_PROC_ROOM_TIME} enter Rm time {POST_CASE.LEAVE_PROC_ROOM_TIME} Lv Rm time I use these fields for times on the report. I need to have a formula that will see the first 30 min and then see the remaining time...

I have a validation report that checks for different Staff people in Surgery. The Report only looks at one Nursing Record at a time. They are linked by Case_No. I have 4 formulas that all follow the same pattern. I have created 4 alias to the same table - Post_Resource. The Post_Resource...

okay, I need the formula to check the different role codes. for the example I have been using for Provider I need to check for Role code 1 or 64. If they are not present, then I need to give the error msg "please check a Provider". I have 4 Roles to check for: Provider [1,64] Anesthesiologist...

Okay, I understand a bit more. The problem is that when I usually check for a code file I check if it is a empty/null field or if there is something in it. it would look like this: if {POST_RESOURCE.ROLE_CODE}= 1 then "I am not a empty field " Thus I don't generate a error msg. if...

Hi all, I have some code that works. WhileReadingRecords; Local StringVar strValidate2; IF {POST_RESOURCE.ROLE_CODE} in [1,64] then // No Provider Code if strValidate2 = "" Then strValidate2 := 'Please Check the Provider Field' else strValidate2 := strValidate2 &...

Okay, I thought that each of the different if-then-else statements that are separated by the ; means that they start over. Is that right? All the formulas are not interdependent. They are checking the same fields, but the formulas do not depend on each other. I thought it is checking first...

Okay, I thought that each of the different if-then-else statements that are separated by the ; means that they start over. Is that right? All the formulas are not interdependent. They are checking the same fields, but the formulas do not depend on each other. I thought it is checking first...

Okay, I was trying to cut and paste the extraneous info in my formula, thus the mistake in the field name. Here is the full formula. It checks first if the bovie is used, then it checks if the coag & cut is being used, then all the code checks are for bovie pad placement. Thus...

Okay, I guess I don't quite understand null. Here is the problem. I have a forumula that checks if a bovie is being used or not. This formula works. if ( isnull({WP_CAUTERY_DTL.SERIAL_NO_CODE}) ) then "No Bovie" else 'bovie used' However if I try this forumula (not null) then it doesn't...

Thank you so much! That works perfectly! Is there a faq that covers things like you mentioned above? I would love to know more tricks like that! >>First, you should set off "or" statements in parens so that it is clear what clauses belong to each other. You also should test for nulls before...

Okay I have a formula that should be working, but isn't. here is the formula: if {WP_INTRA_OP_02.TOURN_UP1_TIME} <> datetime(1800,01,01,00,00,00) OR {WP_INTRA_OP_02.TOURN_DOWN1_TIME} <> datetime(1800,01,01,00,00,00) and {WP_MISC.CODE_17} = 0 or isnull({WP_MISC.CODE_17}) and...

You are so right! I re-checked my formulas, and I had a little boo-boo (typo) in it. Thank you so much! Lareya! I will continue to re-use this convention, and place multiple sections in the header to supress, and I think my validation section will work quite will. Thanks again...