Search:

I can't find the thumbs up on the thread tools menu, sorry!

"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!

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...

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.

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...

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....

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...