Remove milliseconds from date

SimonKing

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

ArborRose

What's the language?

ArborRose

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);

SimonKing

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

ArborRose

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