Conectare
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Date order is inconsistent for Excel Timesheet report.

Răspuns Date order is inconsistent for Excel Timesheet report.

  • 5 iulie 2012 12:53
     
     
    Sign in pentru a vota
    0

    Hi all,

    PS 2010 ,The Date Order in the Period Start Date and Period End Date is inconsistent. Sometimes DD/MM/YYYY, sometimes MM/DD/YYYY.i have Users from different regions.

    Thanks,

    Kirtesh

    kirtesh

     

Toate mesajele

  • 9 iulie 2012 06:59
     
     Răspuns
    Sign in pentru a vota
    0

    Kirtesh,

    If the column is formatted using a * denoted date format, it will use the user's local regional format for the date. If you want it fixed across all locales, do not use a * date format in Excel.

    Treb Gatte

     
  • 10 iulie 2012 06:45
     
     
    Sign in pentru a vota
    0

    First i change the regional setting for the user who is opening the project it solve the problem bot not entirely.

    after your suggestion i made changes in the excel and now it is working perfectly.

    kirtesh