Convert Excel formula to work in MS Access -- 2
$15 USD
Pagado a la entrega
Need the following excel formula converted into a ms access formula
=IF(J886="","",TODAY()-J886)
where j886 is [DATEexp1]
So it should be something like IIf([DATEexp1]="","",Date()-[DATEexp1])
but i cannot get this to work. your help is grately appreciated!
Nº del proyecto: #8277126
Sobre el proyecto
Adjudicado a:
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database formula. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating Más
22 freelancers están ofertando un promedio de $18 por este trabajo
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Más
What is dateexp1 ? A field name ?************************************************************************
Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Access as a front end as well as back end. I Más
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you need the following excel formula converted into a ms access formula. =IF(J886="","",TODAY()-J886) I have been u Más
Hi im an expert in .Net and vba applications What you need to implement is the following Dim o As String Dim s As String s = "01/08/2015" o = IIf(Not IsDate(s), "", DateDiff("d", s, Date)) Regards Carlo Más
Hi, I have right formula for you. I tested, it is working. Hope, you are good people and will not leave me without award ;). IIf(IsEmpty([DATEexp1]),"",Date()-[DATEexp1]) Best regards, Más
You should use this: if Nz([DATEexp1],"")<>"" then [DATEexp1]=Date()-[DATEexp1] Thanks for reading my proposal.
I have over 8 years of experience working with MS Access applications. Have developed a number of database applications using MS Access VBA. Could design reports to any level of complexity. Development of fully normali Más
Hi, below is your solution: If condition_1 Then result_1 Else result_else End If If isNull(DATEexp1) Then result="" Else result=DateDiff("d", Date(), DATEexp1) End If Please share more Más
We are happy to provide you with this proposal. We have deployed various MS Applications like Inventory control, school management system, Payments and billings and so on. Our vast experience makes a perfect fi Más
Well, I think your question can be resolved free of charge: IIf([DATEexp1]=null,null,Date()-[DATEexp1])