AutomationEngineer

const parseDateAggressive = function(val) {
  // Handles actual JS Date objects
  if (Object.prototype.toString.call(val) === "[object Date]")
    return new Date(val);

  // Handles Excel serial numbers (e.g. 45123)
  if (typeof val === "number") {
    return new Date(Math.round((val - 25569) * 86400 * 1000));
  }

  // Handles various string formats via Regex
  // ...
};

// Self-Healing Recovery: If the website crashes
// automatically reload and retry export
try {
  const reportsMenu = invoiceFrame.locator('.clsmainmenu')
    .filter({ hasText: /^Reports$/i }).first();
  await reportsMenu.waitFor({ state: 'visible', timeout: 10000 });
  await reportsMenu.click();
} catch (e) {
  console.log('Website crashed. Initiating recovery...');
  // Click Accounts tab to force-reload the iframe
  await page.getByText(/accounts/i).first().click();
  // Wait for iframe to respawn
  await invoiceFrame.locator('span[data-key="t-Payemt"]')
    .waitFor({ state: 'visible', timeout: 60000 });
  console.log('Iframe recovered. Retrying...');
}