Search results

I have some values being passed to my query in a date field that I can't figure out how to covert to dd/mm/yyyy. Here are a couple of the dates 109415 = 04/15/2009 110112 = 11/12/2010 1100208 = 02/08/2010 Anyone have a method for getting this through as a "regular" date for me? Thanks

I would like to duplicate an excel formula that converts a date to ISO Week, but it is daunting to look at. I would consider using a user created function for it, but have never had luck getting them to work. Here is the excel...

Hi, I'm trying to find a count of events in my table that occur in the last 90 days. This is the formula I'm using, but the value being returned is the count of the entire set of occurrences. Last90: DCount("[LastOfEXCEPTION_CODE]","TardySelect","[DATE] between Date() and Date()-90") What...