TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
if [Date] Is null then...
Hi folks.
I am new to this in all honesty. I have used MS Access quite a bit in the future and I am already finding this pretty easy to navigate and learn, although some basic syntax for simple formulas is causing me some issues...
Can anyone help me with what the syntax if for a if statement that is just looking to see if a date field is blank..
if([Active To] = "", "Active","In-Active")
I have tried Is Null etc and I can't get anything to work. lol.
The [Active To] field is a Date format fyi.

Date Created
3/6/2023 11:03:01 AM
Date Updated
3/6/2023 12:14:13 PM
calvin peters 3/6/2023 11:11:27 AM
Looks like a job for IsNull() at a glance

If(IsNull([Active To]), "Active","In-Active")

All the formula syntax can be found here:

Been at this a long time and still constantly refer to this section.
cooper collier  3/6/2023 11:17:52 AM
This is what you need. I just tested it in one of my databases, if it does not work in yours something else is going on so email me cooper@frobbit,com

If(IsNull([Active To]),"In-Active","Active")
JonnyGee 3/6/2023 12:14:13 PM
Works perfectly dude!! Thank you!
Yeah I took a look at that but I couldn't see anything related to how it handles dates and I would have never have guessed in a million years to have the IsNull first....
Thank you again... I am getting there slowly, but it seems little silly things like that slow me down something chronic!
Have a nice day!
Back to Search Results