I have this query with various dates per record, i.e. status tracking. Each record has values for at least the first date, but not necessarily any more dates. I've tried to create a Public Function which will return the string value of month & date:
1/15/2015 "0115"
2/1/2014 "0201"
10/14/2016 "1014"
The concept is to compare dates by month and day WITHOUT regard to the year. If a date field does not have a value, I would like to return "0000", or something other than "Error". I have tried
IsNull()
IsDate()
month and day extraction and comparing these results to 0
Obviously I'm missing something.... Any help would be greatly appreciated
1/15/2015 "0115"
2/1/2014 "0201"
10/14/2016 "1014"
The concept is to compare dates by month and day WITHOUT regard to the year. If a date field does not have a value, I would like to return "0000", or something other than "Error". I have tried
IsNull()
IsDate()
month and day extraction and comparing these results to 0
Obviously I'm missing something.... Any help would be greatly appreciated