I was wondering how to get this statement to work
IIF(Start/date="year(2012)",yes,no)
I have tried but all it does is say all yes, or all no.
My table has the correct format of date/time, I tried 2013, 2014, but still the same thing. If that doesn't/does does Access have excels own version of "Like" or/and "Contains?" Thanks!:banghead:
IIF(Start/date="year(2012)",yes,no)
I have tried but all it does is say all yes, or all no.
My table has the correct format of date/time, I tried 2013, 2014, but still the same thing. If that doesn't/does does Access have excels own version of "Like" or/and "Contains?" Thanks!:banghead:
IIf statement with dates
0 commentaires:
Enregistrer un commentaire