Formula for putting As at Date functinality in a BAQ

Please formulate a complete question. Refer to Tips for asking question on the forum - Experts’ Corner - Epicor User Help Forum (epiusers.help) for great suggestions.