M Muna2009 Sep 4, 2009 #1 I need to calculate datediff for the field (yes/no). If then statement did not work please help me how to get result
I need to calculate datediff for the field (yes/no). If then statement did not work please help me how to get result
D Dirk Goldgar Sep 4, 2009 #2 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 Click to expand... 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.
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 Click to expand... 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 Sep 8, 2009 #3 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 Click to expand... I found the solution on Access website. ABC_Days: IIf([ABC]=-1, AND DateDiff("d",[Start_Date],[Completed_Date]))
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 Click to expand... I found the solution on Access website. ABC_Days: IIf([ABC]=-1, AND DateDiff("d",[Start_Date],[Completed_Date]))
M Muna2009 Sep 8, 2009 #4 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 Click to expand... I found the solution on Access website. ABC_Days: IIf([ABC]=-1, AND DateDiff("d",[Start_Date],[Completed_Date])) Click to expand... There should not be AND the correct on is below ABC_Days: IIf([ABC]=-1,DateDiff("d",[Start_Date],[Completed_Date]))
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 Click to expand... I found the solution on Access website. ABC_Days: IIf([ABC]=-1, AND DateDiff("d",[Start_Date],[Completed_Date])) Click to expand... There should not be AND the correct on is below ABC_Days: IIf([ABC]=-1,DateDiff("d",[Start_Date],[Completed_Date]))