Search:
Type: Posts; User: vicki61428
Search:
Search took 0.02 seconds.
-
February 12th, 2013, 02:02 PM
I can't find the thumbs up on the thread tools menu, sorry!
-
February 12th, 2013, 01:59 PM
"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!
-
February 12th, 2013, 01:40 PM
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...
-
February 12th, 2013, 12:50 PM
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.
-
February 12th, 2013, 12:20 PM
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...
-
February 12th, 2013, 11:47 AM
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....
-
February 12th, 2013, 09:49 AM
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...
|
Click Here to Expand Forum to Full Width
|