Recent content by cutpen

Thank you

Thank you, it worked and I hope you have a good day

I am very sorry if I have affended anyone by not replying. I am new at this. I have used what was given me and it did not work. I guess it is because I am trying to concatenate it to others see below. {hrpersnl.p_lname}&" "&{hrpersnl.p_fname}&" "& left{hrpersnl.p_mi,1}

What is the formula to only show the first letter of a name? Thanks

Thanks

What is the formula to remove the dashes from a Social Security Number? I have 8.5 version. Thanks, Penny

How do I change a date/time field to only a date field in the 8.5 version? I want to use the select expert on this field and be able to put only a date. Thanks, Penny

Has anyone ever created a report that looks like a calendar?

Thanks Rosemary, your have been a great help!

now when I run the report, it says "this string is non-numeric" What could this mean since the field says that it is a number?

I am sorry to be so much trouble. Here is what I have: NumberVar T := {HMN_UNSHDDAY.S_START}; numbervar l := len(totext(tonumber(t))); numbervar c := select(l) case 0 : 0 case 1 : 0 case 2 : 0 case 3 : 1 case 4...

Sorry, but I am getting an error message saying "the remaining text does not appear to be part of the formula" inbetween the bottom two lines. Is this in crystal syntax? case 4 : 2; NumberVar H := tonumber(left(totext(t),c));

I'm sorry, maybe I don't understand. Will you check my formula? NumberVar T := {HMN_UNSHDDAY.S_START}; NumberVar H := tonumber(left(totext(t),2)); NumberVar M := tonumber(totext(t) [3 to 4]); time(h,m,0)

That makes 1500 go to 1:50am instead of 6:00PM

Yes, I am using 8.5. Notice that field of start time that has 1500 (Number) I wrote a formula time(field) that shows as 12:00AM. e.g. start time @time 1500 12:00AM