Returns 12:59:59pm time for the date passed. Useful for date only search ranges end value

public static DateTime EndOfDay(DateTime date);