CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: vicki61428

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    7,684

    Re: IIF () or If Then Else?

    I can't find the thumbs up on the thread tools menu, sorry!
  2. Replies
    9
    Views
    7,684

    Re: IIF () or If Then Else?

    "Check it and you must test with: Date({table.datefield}) = Date(0,0,0) " It should be <> Date(0,0,0). It worked then. Thank you very much for your help!
  3. Replies
    9
    Views
    7,684

    Re: IIF () or If Then Else?

    If Convert Database Values to Default is not checked and I use: If Not IsNull({@Diag Date}) Then {@Diag Date}
    Else
    If Not IsNull({@Consult Date}) Then {@Consult Date}
    Else
    {@Create Date} it is...
  4. Replies
    9
    Views
    7,684

    Re: IIF () or If Then Else?

    The IIF() function and the if then else statement both seem to test the first part of the code, If Not IsNull({@Diag Date}) Then {@Diag Date}, and it does not go on from there.
  5. Replies
    9
    Views
    7,684

    Re: IIF () or If Then Else?

    All three formula fields, {@Diag Date}, {@Consult Date} and {@Create Date}, use the date() function to pull the date part of three date-time fields, DX_Dtm, Diag_DTtm, and Create_DTtm. So they are...
  6. Replies
    9
    Views
    7,684

    Re: IIF () or If Then Else?

    Hi,

    Thank you for your response. With the code that you gave me, only the value of the {@Diag Date} field populates the formula field where all three fields used in the code are populated....
  7. Replies
    9
    Views
    7,684

    IIF () or If Then Else?

    Hello,

    I have three fields Create Date, Consult Date, and Diag Date. I want to create a formula field that will test if first, if Diag Date is populated, then the value of the formula field will...
Results 1 to 7 of 7





Click Here to Expand Forum to Full Width

Featured