audience

In the context of Microsoft Project Web Access (PWA) and Microsoft Project, the concept of a “Date Converter Tool” generally refers to managing and troubleshooting date formatting differences between local system settings (like Windows regional settings) and the cloud-based Project environment, or translating durations to match standardized working calendars.

If you are encountering scheduling mismatches, misaligned time zones, or issues where dates format incorrectly when exporting data, you can resolve these using the native localization and formatting features within the application. 1. Setting Date Formats in Project Web Access

Project Web Access (PWA) inherits its date and time formats from the underlying Microsoft 365 or Power Platform environments. If your start and finish dates are displaying in an unexpected order (e.g., MM/DD/YYYY vs. DD/MM/YYYY), you can adjust your personal settings:

Navigate to your Project interface within the Power Apps environment.

Select the Settings Gear icon in the top right corner of your screen. Open Personalization Settings. Select the Formats tab.

Change the Current Format dropdown to your preferred date/time configuration. 2. Resolving Excel Export Date Errors

When users export project data to Excel, dates sometimes include unwanted timestamps (e.g., 10/10/2026 becomes 10/10/2026 8:00 AM). To normalize these dates upon export:

Use Excel’s DATEVALUE Function: In a blank adjacent column, use the formula =DATEVALUE(A2) (assuming A2 is the Project date cell) to strip away unwanted time stamps.

Custom Format: Highlight the exported cells in Excel, press Ctrl+1, and select a custom Date format (e.g., mm/dd/yyyy) under the Number tab. 3. Understanding the Working Time Converter (Calendars) What is Project for the web? – Microsoft Support