welcome to XRM blog

Keep in touch with latest CRM/ERP articles

To remain competitive your organisation must be efficient across the business process spectrum. To do so you need to take sound decisions based on a balance between the cost and risk. To do so you will be heavily dependent on your content management in itself needs...

image
Blog

How do I format a Microsoft JSON date?

By Anshuman Trivedi on 11/27/2016

Recently in my current project as per requirement of client. I had to Format Microsoft JSON date.

JSON Dates are not dates – they are Strings So I thought of writing this functions for Formatting JSON Date.

Step-1: Write a Function-

            function parseJsonDate(jsonDate) {

                        var offset = new Date().getTimezoneOffset() * 60000;

                        var parts = /\/Date\((-?\d+)([+-]\d{2})?(\d{2})?.*/.exec(jsonDate);

                        if (parts[2] == undefined)

                                     parts[2] = 0;

                        if (parts[3] == undefined)

                                     parts[3] = 0;

                        return new Date(+parts[1] + offset + parts[2]*3600000 + parts[3]*60000                           + 86400000);

                        };

 

            function JSONDate(){

var reviewdate = parseJsonDate(entity.xrm_Date);     

 var date = "";

                        var month = "";

                        if ((reviewdate.getDate()) < 10) {

                                    date = "0" + reviewdate.getDate();

                        }

                        else {

                                    date = reviewdate.getDate();

                        }

                        if ((reviewdate.getMonth() + 1) < 10) {

                                    month = "0" + (reviewdate.getMonth() + 1);

                        }

                        else {

                                    month = (reviewdate.getMonth() + 1);

                        }

                        reviewDate = date + "/" + month + "/" + reviewdate.getFullYear();

                        bookReviewdate = bookReviewdate+" "+reviewDate;

            }

 

Step-2: Copy and paste this function into your JS file.

Step 3: Click on OK and then Save and Publish.  


 

Javascript
MS CRM 2016
Blog Calendar
Blog Calendar List
2022 Jun  5  2
2022 May  3  2
2022 Apr  4  2
2022 Mar  1  1
2022 Feb  2  1
2022 Jan  1  1
2021 Dec  3  1
2021 Nov  2  1
2021 Oct  1  1
2021 Sep  10  1
2021 Aug  34  5
2021 Jul  34  4
2021 Jun  485  5
2021 May  25  3
2021 Apr  814  3
2021 Mar  76  5
2021 Feb  964  7
2021 Jan  1079  9
2020 Dec  278  7
2020 Sep  58  3
2020 Aug  365  3
2020 Jul  90  1
2020 Jun  55  3
2020 Apr  36  3
2020 Mar  11  2
2020 Feb  26  5
2020 Jan  33  7
2019 Dec  17  4
2019 Nov  12  1
2019 Jan  33  3
2018 Dec  39  4
2018 Nov  68  3
2018 Oct  18  3
2018 Sep  815  11
2018 Aug  6  2
2018 Jun  11  1
2018 Jan  68  2
2017 Sep  576  5
2017 Aug  17  1
2017 Jul  17  2
2017 Jun  58  2
2017 May  21  1
2017 Apr  35  2
2017 Mar  120  4
2017 Feb  592  4
2016 Dec  192  3
2016 Nov  530  8
2016 Oct  276  10
2016 Sep  443  6
2016 Aug  39  1
2016 Jun  1825  6
2016 May  108  3
2016 Jan  71  2
2015 Dec  405  6
2015 Nov  4  1
2015 Oct  13  1
2015 Sep  1416  6
2015 Aug  14  1
2015 Jul  127  2
2015 Jun  10  1
2015 May  20  1
2015 Apr  30  3
2015 Mar  80  3
2015 Jan  5316  4
2014 Dec  17  1
2014 Nov  2252  4
2014 Oct  67  1
2014 Sep  106  2
2014 Aug  5121  1
2014 Jul  48  2
2014 Apr  2515  12
2014 Mar  300  19
2014 Feb  242  8
2014 Jan  1510  16
2013 Dec  21  2
2013 Nov  684  2
2013 Oct  256  3
2013 Sep  11  1
2013 Aug  40  3
2013 Jul  213  1
2013 Apr  56  6
2013 Mar  2139  10
2013 Feb  325  4
2013 Jan  288  2
2012 Nov  54  2
2012 Oct  490  10
Tag Cloud
Interested in our services? Still not sure about project details? get a quote