1. Home
  2. Forum
  3. Vue
  4. How to display date in UK format not US format

How to display date in UK format not US format

Hello,

Actually, I want to display dates in UK format not US.
I already changed the locale prop to 'en-GB' but it didn't work.

Thanks a lot,

19 Replies
AS Aravinthan Seetharaman Syncfusion Team April 1, 2021 06:25 PM UTC

Hi Omar, 
 
Thanks for contacting Syncfusion Support. 
 
We have checked your requirement. We can achieve your requirement by importing required files as in the sample. Please refer the below code snippet and sample. 
 
<template> 
  <div id="app"> 
    <div id="container"> 
      <ejs-spreadsheet ref="spreadsheetRef" :created="created" locale="en-GB"> 
        <e-sheets> 
          . . .  
          </e-sheet> 
        </e-sheets> 
      </ejs-spreadsheet> 
    </div> 
  </div> 
</template> 
 
<script> 
import Vue from "vue"; 
import { L10n, setCulture, setCurrencyCode, loadCldr } from "@syncfusion/ej2-base"; 
import { SpreadsheetPlugin } from "@syncfusion/ej2-vue-spreadsheet"; 
import * as dataSource from "./default-data.json"; 
 
Vue.use(SpreadsheetPlugin); 
 
import * as numberingSystems from "./numberingSystems.json"; 
import * as gregorian from "./ca-gregorian.json"; 
import * as numbers from "./numbers.json"; 
import * as timeZoneNames from "./timeZoneNames.json"; 
loadCldr(numberingSystems, gregorian, numbers, timeZoneNames); 
 
setCulture("en-GB"); 
export default { 
  data: function () { 
    return { 
      view: "Details", 
      dataSource: dataSource.defaultData, 
      width1: 180, 
      width2: 130, 
      width3: 120, 
    }; 
  } 
. . . 
</script> 
 
 
 
Could you please check the above details, and get back to us, if you need assistance on this. 
 
Regards, 
Aravinthan S



OM Omar April 5, 2021 05:23 PM UTC

Hi Aravinthan,

I followed the exact demo and copied the same files.
But it still the US Format.

Please check the image attached.

Thanks

Attachment: Screenshot_20210405_182116_f157a354.rar

SP Sangeetha Priya Murugan Syncfusion Team April 6, 2021 11:17 AM UTC

Hi Omar, 
 
Thank you for your update. 
 
We have checked your reported issue and we suspect that you have faced the issue with the normal format dropdown list. And we have already logged this as defect and the fix will be available in our April 28th weekly patch release, we appreciate your patience until then. You can track the status of this defects using below link from our feedback portal,  
 
 
Could you please check the above details and kindly get back to us with more details if we misunderstood your issue or need further assistance on this. 
  
Regards, 
Sangeetha M 


OM Omar April 28, 2021 03:37 PM UTC

Hello,

So, I just updated to the latest version "@syncfusion/ej2-vue-spreadsheet": "^19.1.58" 
and followed all steps. but still the date displays as below:


SP Sangeetha Priya Murugan Syncfusion Team April 29, 2021 11:30 AM UTC

Hi Omar, 
 
Thank you for your update. 
 
We have checked your reported issue and the date format applied properly for en-GB culture in our latest version. We suspect that you haven’t properly refer the cldr-data package files in your application as like we have referred in our previously update sample. For your convenience, we have prepared the sample and video demonstration of this issue. Please find the link below. 
 
 
 
For more details, regarding the globalization. Please refer the below link. 
 
 
Could you please check the above link and ensure whether you have properly referred the cldr-data package files in your application. And kindly get back to us, if you still need any further assistance on this. 
 
Regards, 
Sangeetha M 


OM Omar April 30, 2021 09:49 AM UTC

Hi Sangeetha,

I followed the example exactly as it is, the thing is that it works fine if I'm typing a date in the spreadsheet.
But if I'm copying or opening a spreadsheet, it displays the US format.

I tried to do so, It didn't even work on the demo itself (please check the recording attached)
and try to open the attached file in the demo environment, you'll find the date format in US.

Thanks

Attachment: Sample_5f7bb8f5.rar

OM Omar May 4, 2021 02:18 PM UTC

Hello,

Any updates on this issue.

SP Sangeetha Priya Murugan Syncfusion Team May 4, 2021 02:45 PM UTC

Hi Omar, 
 
Thank you for your patience. 
 
We have checked your reported requirement and we confirmed this as improvement and the fix will be available in our Essential studio volume 2 2021 release. Which is  scheduled to be rolled out on end of June month. we appreciate your patience until then. You can track the status of this improvement using below link from our feedback portal,  
 
 
Regards, 
Sangeetha M 


OM Omar May 5, 2021 11:28 AM UTC

Hi Sangeetha,

Thanks a lot for your reply, our business flow has been slowed down so much by this issue and we have been waiting for long for the fix.
I really appreciate if it comes a bit quicker.

Thanks a lot

SP Sangeetha Priya Murugan Syncfusion Team May 6, 2021 09:03 AM UTC

HI Omar, 
 
Thank you for your update. 
 
We have checked your reported requirement and we have planned to include this fix in end of May month patch release. We appreciate your patience until then. 
 
Regards, 
Sangeetha M 


OM Omar June 12, 2021 03:00 PM UTC

Any updates on this issue ?

SP Sangeetha Priya Murugan Syncfusion Team June 14, 2021 07:32 AM UTC

Hi Omar, 
 
Thank you for your update. 
 
We have checked your reported issue and we have faced some complexities while implementing this. However, are looking this issue with high priority and we will include this in our June 16th weekly patch release. We appreciate your patience until then. 
 
Regards, 
Sangeetha M 


SP Sangeetha Priya Murugan Syncfusion Team June 17, 2021 07:53 AM UTC

 
Thank you for your patience. 
 
We are glad to announce that our weekly patch release (19.1.69) is rolled out. We have included the fix for the reported issue in this release. So, we suggest you upgrade our Syncfusion NPM Spreadsheet package to our latest version to resolve this issue in your end.   
 
 
Regards, 
Sangeetha M 


OM Omar June 17, 2021 10:38 AM UTC

Hello, I just update to the latest version of npm and followed all of the previous steps
and still the same issue when I open an excel, please notice MS Excel on the left and SF spreadsheet on the right.
Typing a date works fine but opening a document with dates doesn't get the correct format


SP Sangeetha Priya Murugan Syncfusion Team June 18, 2021 07:12 AM UTC

Hi Omar, 
 
Thank you for your update, 
 
We have checked your reported issue and the UK date formats works properly in our end with your provided excel file. For your convenience, we have prepared the video demonstration with our latest package by importing your provided excel file. Pease find the link below. 
 
 
 
Kindly ensure whether you have referred the latest packages in your node modules folder. And check again by after clearing the browser cache. 
 
Could you please check the above details and get back to us with more details like issue replicable sample and video, if you still getting the same issue or need further assistance on this. 
 
Regards, 
Sangeetha M 


OM Omar June 19, 2021 10:04 AM UTC

Hi Sangeetha,

I tried to open the file in the demo link but it keeps loading forever till the request fails with 502 status.
Please check the attached video.

Secondly, I updated to "@syncfusion/ej2-vue-spreadsheet": "^19.1.69"​

And imported all of the custom files exactly as the demo, I made sure as well that date format on my local machine is set to UK, but still getting the same US format here:


I even tried to open the file on the actual demo link here:
https://ej2.syncfusion.com/vue/demos/?&_ga=2.133550089.669649612.1624096807-259303177.1608820189&_gac=1.117190260.1622221333.CjwKCAjwqcKFBhAhEiwAfEr7zXOBzjMdHGf8F2LcoWNYkPN3MqvKilitVihdXxr_DjVjs_KgZKw41hoCKg0QAvD_BwE#/material/spreadsheet/default.html

But no success, same issue happens.

Please assist to help with this issue asap, because it's been a long time since I reported this issue and it still not resolved.
Really appreciate your help.


Thanks,



Attachment: 502WhenOpeningExcel_9b4903e.rar

SP Sangeetha Priya Murugan Syncfusion Team June 22, 2021 12:17 PM UTC

Hi Omar, 
 
Thank you for your update. 
 
We have checked your reported issue and we would let you know that our demo site doesn’t referred the cldr-data packages for localization. So, please check this with the local sample with the local service for import/export action.  
 
For your convenience, we have prepared the sample that referred the local service for open/save action. In this sample, your provided excel file loaded initially using open method in created event. And the date format working properly in our end. Please find the link below. 
 
 
 
Note: launch the service first and then open the vue(codesandbox) sample for open/save action. 
 
Please check the above link and get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M 


OM Omar July 9, 2021 02:09 PM UTC

Hello,


Guys please check the sample link you sent

Sample Link: https://codesandbox.io/s/vue-template-forked-96okv?file=/src/App.vue 

the format is not UK format at all:

Please help to assist to resolve this as soon as possible, because this has been pending for too long and it's obstructing our business processes.


Thanks,



AS Aravinthan Seetharaman Syncfusion Team July 16, 2021 06:37 AM UTC

Hi Omar, 
 
We have created an incident under your direct trac account. Please follow the incident for further assistance. 
 
Regards, 
Aravinthan S 


Loader.
Up arrow icon