Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DekeyBoy

  1. DekeyBoy

    Checking a string for null/blank then assigning a value

    Ah, check for null first - interesting. Thanks - that was it! Can I ask another question please? I have a few books on Crystal, but none really deal with programming and syntax. What I seem to need most is just a wide range of examples for all types of forumulas. Can anyone recommend anything...
  2. DekeyBoy

    Checking a string for null/blank then assigning a value

    Thanks everyone. It turns out my string field "name1" is always either filled with some text or null, so for now I am getting away with just testing for null, but it seemed I had the problem with the "isnull OR isblank" test. I put in Durango's formula (which tests for null or blank), but in...
  3. DekeyBoy

    Checking a string for null/blank then assigning a value

    Hello, I'm certain I am missing some little thing, but I am having trouble with the following. My data has two fields that are strings. Let's call them: Name1 Name2 All I want to do is this: If Name1 is blank or if Name1 is null show Name2 Else show Name1 Thanks in advanced
  4. DekeyBoy

    determine day of week from date/time

    Hi, rather than start a new thread, this seemed very related to what I am trying to do, so I thought I would add this here. Thanks in advanced! Okay, I have v8.5. I have time fields I want to calculate. Lets say we have: PlannedStartTime ActualStartTime PlannedEndTime ActualEndTime I would...
See more

Part and Inventory Search

Back
Top