M
Muna2009
I need to calculate datediff for the field (yes/no). If then statement did
not work please help me how to get result
not work please help me how to get result
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dirk Goldgar
Muna2009 said:I need to calculate datediff for the field (yes/no). If then statement
did
not work please help me how to get result
Please explain in more detail. You can't get a DateDiff on a yes/no field,
so you must be referring to some other field or fields.
M
Muna2009
Muna2009 said:I need to calculate datediff for the field (yes/no). If then statement did
not work please help me how to get result
I found the solution on Access website.
ABC_Days: IIf([ABC]=-1, AND DateDiff("d",[Start_Date],[Completed_Date]))
M
Muna2009
Muna2009 said:Muna2009 said:I need to calculate datediff for the field (yes/no). If then statement did
not work please help me how to get result
I found the solution on Access website.
ABC_Days: IIf([ABC]=-1, AND DateDiff("d",[Start_Date],[Completed_Date]))
There should not be AND the correct on is below
ABC_Days: IIf([ABC]=-1,DateDiff("d",[Start_Date],[Completed_Date]))