Remove milliseconds from date

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
    ArborRose Coach

    What's the language?

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

  • ArborRose
    ArborRose Coach

    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

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

  • ArborRose
    ArborRose Coach

    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! **

Categories