What is the process for increasing the number of days in a timestamp?

Question

What is the process for increasing the number of days in a timestamp?

I am struggling to calculate the correct end date from a given start date and duration in my code.

exports.terminateStoreAd = functions.https.onRequest(async(req, res) => {
        try {
            const snapshot =await admin.database().ref("StoreAds").once("value");
            if (snapshot.exists()) {
                snapshot.forEach(snapData => {
                    if (snapData.exists()) {
                        const endDate=new Date(snapData.val().startDate).getTime()+(snapData.val().duration*24*60*60*1000);
                        res.send(""+endDate);
                    }
                });
                res.send("done")
            }
        } catch (error) {
            console.log("terminateStoreAd error :" + error.message); 
        }
    });

Given data:

Start date: 1559449773

Duration: 5 days

Incorrect end date calculation: 1991449773

I appreciate your assistance in fixing this issue. Thank you!

javascript typescript google-cloud-functions

Answer 1

Answer №1

When working with date calculations in JavaScript, it's important to consider whether the startDate is already in milliseconds or a Date string. To convert the required date into milliseconds, you can use the following code:

If startDate is in milliseconds:

const endDate = snapData.val().startDate + snapData.val().duration*24*60*60*1000;

On the other hand, if startDate is a Date string:

const endDate = (new Date(snapData.val().startDate)).getTime() + snapData.val().duration*24*60*60*1000;

This code snippet will help you obtain the endDate in milliseconds for your calculations.

Answer 2

When working with date calculations in JavaScript, it's important to consider whether the startDate is already in milliseconds or a Date string. To convert the required date into milliseconds, you can use the following code:

If startDate is in milliseconds:

const endDate = snapData.val().startDate + snapData.val().duration*24*60*60*1000;

On the other hand, if startDate is a Date string:

const endDate = (new Date(snapData.val().startDate)).getTime() + snapData.val().duration*24*60*60*1000;

This code snippet will help you obtain the endDate in milliseconds for your calculations.

Answer 3

Answer №2

If we have a start date of 2019-05-01, determining the date that is 5 days later can be achieved by simply creating a new date with the appropriate parameters.

It's important to remember that the month in JavaScript is zero-indexed, meaning May (the 5th month) is actually index 4. So, if I want the date 5 days after May 1st, I would use 1+5 as the day value:

const startDate = new Date(2019, 4, 1);
const endDate = new Date(startDate.getFullYear(), startDate.getMonth(), startDate.getDate()+5);

console.log(`Start Date: ${startDate}, End Date: ${endDate}`);
console.log(`Start Date: ${startDate.valueOf()}, End Date: ${endDate.valueOf()}`);

Answer 4

If we have a start date of 2019-05-01, determining the date that is 5 days later can be achieved by simply creating a new date with the appropriate parameters.

It's important to remember that the month in JavaScript is zero-indexed, meaning May (the 5th month) is actually index 4. So, if I want the date 5 days after May 1st, I would use 1+5 as the day value:

const startDate = new Date(2019, 4, 1);
const endDate = new Date(startDate.getFullYear(), startDate.getMonth(), startDate.getDate()+5);

console.log(`Start Date: ${startDate}, End Date: ${endDate}`);
console.log(`Start Date: ${startDate.valueOf()}, End Date: ${endDate.valueOf()}`);

Answer 5

Answer №3

finally found the solution I was looking for!

exports.endStoreAd = functions.https.onRequest(async(req, res) => {
try {
    const snapshot = await admin.database().ref("StoreAds").once("value");
    const promises = [];
    if (snapshot.exists()) {
        snapshot.forEach(childSnapshot => {
            const endTime = childSnapshot.val().startTime + childSnapshot.val().duration  * 86400;
            const todayTime = Math.round(new Date().getTime()/1000);
            if (endTime <= todayTime) {
                promises.push(
                    admin.database().ref("StoreAdsHistory").child(childSnapshot.key).set(childSnapshot.val()),
                    childSnapshot.ref.remove(),
                    res.send()
                );
            }
        });
       } 
       await Promise.all(promises);
    } catch (error) {

}

});

Answer 6

finally found the solution I was looking for!

exports.endStoreAd = functions.https.onRequest(async(req, res) => {
try {
    const snapshot = await admin.database().ref("StoreAds").once("value");
    const promises = [];
    if (snapshot.exists()) {
        snapshot.forEach(childSnapshot => {
            const endTime = childSnapshot.val().startTime + childSnapshot.val().duration  * 86400;
            const todayTime = Math.round(new Date().getTime()/1000);
            if (endTime <= todayTime) {
                promises.push(
                    admin.database().ref("StoreAdsHistory").child(childSnapshot.key).set(childSnapshot.val()),
                    childSnapshot.ref.remove(),
                    res.send()
                );
            }
        });
       } 
       await Promise.all(promises);
    } catch (error) {

}

});

What is the process for increasing the number of days in a timestamp?

Answer №1

Answer №2

Answer №3

Similar questions

Deleting an item from an array in MongoDB

When working with Typescript, encountering difficulty in locating or importing modules from a parent directory that is one level above the tsconfig.json file is

Tips for resolving TS7022 issue within Vue Composition API

Compiling and rendering HTML code from a file with AngularJS

Creating a seamless integration between Angular 2's auth guard and observables to enhance application security

What is the best way to incorporate a Json file into a JavaScript file?

Exploring the creation of an Angular service that utilizes HttpClient for making GET requests, with a focus on the different

Retrieving the maximum values from JSON data using D3

What is the best way to convert the javascript code into clojurescript?

I am looking to implement pagination in my Elasticsearch outcomes by incorporating a new set of results beneath the existing one using React JS

Angular's Not In operator can be used to filter out unwanted

Pressing buttons activates key responses

Upload the image data into the input file tag

Preserving client-side page state during page reloads in angular.js apps

Is the size of the array significant in the context of JavaScript here?

Tips for recognizing users in socket.io?

Displaying JavaScript Countdown in PHP Table

Generating an array of keys from duplicated values in Typescript

The initial size of C3 charts is unnecessarily large upon loading

Understanding surface orientations of moving objects