Remove milliseconds from date

Options
SimonKing
SimonKing Member
edited May 17 in Connectors

I am building a connector which requires the date in the API call, however it needs to be format YYYY-MM-DDTHH:MM:SSZ.

today = new Date(); provides the date however it also includes milliseconds. How can I get the date without milliseconds or remove them after getting the date? I will then also need to remove 30 days as I need to two date to only pull in data from last month until now (or last 30 days)

thanks

Answers

  • ArborRose
    Options

    What's the language?

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ArborRose
    Options

    In Python…

    today = datetime.utcnow()
    today = today.replace(microsecond=0)
    past_date = today - timedelta(days=30)
    formatted_today = today.strftime('%Y-%m-%dT%H:%M:%SZ')
    formatted_past_date = past_date.strftime('%Y-%m-%dT%H:%M:%SZ') print("Current date in required format:", formatted_today)
    print("Date 30 days ago in required format:", formatted_past_date)

    In Javascript…

    let today = new Date();
    today.setMilliseconds(0);
    let pastDate = new Date(today);
    pastDate.setDate(today.getDate() - 30);
    function formatDate(date) {
    let year = date.getUTCFullYear();
    let month = String(date.getUTCMonth() + 1).padStart(2, '0');
    let day = String(date.getUTCDate()).padStart(2, '0');
    let hours = String(date.getUTCHours()).padStart(2, '0');
    let minutes = String(date.getUTCMinutes()).padStart(2, '0');
    let seconds = String(date.getUTCSeconds()).padStart(2, '0'); return ${year}-${month}-${day}T${hours}:${minutes}:${seconds}Z;
    } let formattedToday = formatDate(today);
    let formattedPastDate = formatDate(pastDate); console.log("Current date in required format:", formattedToday);
    console.log("Date 30 days ago in required format:", formattedPastDate);

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • SimonKing
    SimonKing Member
    edited May 17
    Options

    Hi, this is in DOMO, building a custom connector, so a version of JAVA.

  • ArborRose
    Options

    Got it. I have not braved the world of custom connectors yet.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **