My databse appears to be corrupt. If I load up a backup from April 1st, will it work with the latest updated version of my community, which has had the latest version updates applied since April 1st?

If you have newer IPB files than your database, you can upgrade the database to match the files by going to domain.com/admin/upgrade. It will tell you if you need to update the DB.