Get Current Date/time

I am trying to build a connector which needs the call to include the date and time in the header..

Date / Time (x-mc-date)

The x-mc-date header must be created in the following format:

Tue, 24 Nov 2015 12:50:11 GMT

Any ideas how I can get the current date and time and then also in this format?

Thanks

Find more posts tagged with

Accepted answers

eric_tetik

Here's a little more formatting to get the result you need:

var options = {
weekday: 'short',
year: 'numeric',
month: 'short',
day: 'numeric',
hour: '2-digit',
minute: '2-digit',
second: '2-digit',
hour12: false
}
today = new Date();

var date = today.toLocaleDateString("en-AU", options) + ' GMT';

// Replace period with nothing
var date1 = date.replace(".", "");

// Replace all instances of a comma with nothing
var date2 = date1.replace(/,/g, "");

// Re-add the comma after the weekday

var final = date2.substring(0, 3) + ', ' + date2.substring(4);

console.log(final);

Cheers

Eric

Screen Shot 2019-10-15 at 9.19.21 am.png

All comments

Koen

Hello @Simon_King ,

The format to do that can be made in a beastmode (see attached picture). If you make this in a 'dynamic textbox' card, you can set this as a header on your dashboard.

I don't know how to update the time every second.

Best regards,

Koen

Time Format Beast Mode.png

Simon_King

Hi,

thanks for your answer however this date format is required in a connector API call in order to drag the data into Domo.

simon

eric_tetik

Hi there,

If I understood you correctly, you're building a custom connector in Domo and need the current date in the format you specified in order to make an API call. You can do that using pure JavaScript with the code below:

var options = {
weekday: 'short',
year: 'numeric',
month: 'short',
day: 'numeric',
hour: '2-digit',
minute: '2-digit',
second: '2-digit',
hour12: false
}
today = new Date();

var formattedDate = today.toLocaleDateString("en-AU", options) + ' GMT';

console.log(formattedDate);

I've just concatenated the " GMT" part on the end for simplicity

Cheers

Eric

EDIT: documentation for the toLocaleDateString method

Screen Shot 2019-10-11 at 8.52.53 am.png

Simon_King

Eric,

Thats great thanks. Just a minor tweak I get date

Fri., 11 Oct. 2019, 09:28:00 GMT

but need

Fri, 11 Oct 2019 09:28:00 GMT

Just a fullstop and a comma removed

I will have a look but if you know how that would be great

Thanks

eric_tetik

Here's a little more formatting to get the result you need:

var options = {
weekday: 'short',
year: 'numeric',
month: 'short',
day: 'numeric',
hour: '2-digit',
minute: '2-digit',
second: '2-digit',
hour12: false
}
today = new Date();

var date = today.toLocaleDateString("en-AU", options) + ' GMT';

// Replace period with nothing
var date1 = date.replace(".", "");

// Replace all instances of a comma with nothing
var date2 = date1.replace(/,/g, "");

// Re-add the comma after the weekday

var final = date2.substring(0, 3) + ', ' + date2.substring(4);

console.log(final);

Cheers

Eric

Screen Shot 2019-10-15 at 9.19.21 am.png

Simon_King

Great thanks