Remove time from date using javascript and pass it to excel

Question

I'm trying to do excel export using alasql and passing my date,12 Apr 2018 by transforming using below function

    var dateStr = "12 Apr 2018";
    function trandformDate(dateString){ 
        var date = new Date(dateString);
        return new Date(date.setDate(date.getDate() + 1));
    }
    var date = trandformDate(dateStr);

When the excel gets generated I was able to see the date in MM/DD/YYYY format with the timezone.I would like to keep the date and removw timezone from excel.Please let me know how can I send time without timezone to excel so that the format remains the same ie., MM/DD/YYYY

To confirm: you know how to get a datetime into Excel: 4/12/2018 6:30:00 PM but you want to remove the time (so you have 4/12/2018), and you want to do that in JavaScript, so this is not an Excel question, correct? — ashleedawg
– ashleedawg, Commented May 25, 2018 at 6:47
Possible duplicate of How do I remove time part from JavaScript date? — ashleedawg
– ashleedawg, Commented May 25, 2018 at 6:50
Don't put changes in comments, edit the question. It's very unclear. — RobG
– RobG, Commented May 25, 2018 at 12:31

forgottofly · Accepted Answer · 2018-05-28 04:52:37Z

2

Fixed by passing the date and setting timestamp to 0 using setUTC()

var dateStr = "12 Apr 2018";
transformDate(dateString) {
        const date = new Date(dateString);
        const timeStamp = new Date(date.setDate(date.getDate() + 1));
        timeStamp.setUTCHours(0);
        timeStamp.setUTCMinutes(0);
        timeStamp.setMilliseconds(0);
        return timeStamp;
    }
var date = trandformDate(dateStr);

answered May 28, 2018 at 4:52

forgottofly

2,72912 gold badges56 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Benjamhw · Accepted Answer · 2018-05-28 06:06:32Z

0

Simply split the array by space, and then use only the first part of the array.

var date = new Date();
date = date.split(" ")[0];

answered May 28, 2018 at 6:06

Benjamhw

978 bronze badges

Collectives™ on Stack Overflow

Remove time from date using javascript and pass it to excel

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related