JavaScript: Gregorian Date or Julian Date

This will require Builder privileges for setup and implementation.

Using an expression to get the current date may be something you would like to utilize, below is how to use a JavaScript Expression to obtain the Date (Gregorian). Data Type – String

var today=new Date();
var dd=today.getDate();
var mm=today.getMonth()+1;
var yy=today.getYear()+1900;
Y1=mm+'/'+dd+'/'+yy;

Using an expression to get the current date may be something you would like to utilize, below is how to use a JavaScript Expression to obtain the Date (Julian). Data Type – String

Date.prototype.getJulian = function()

{return Math.floor((this / 86400000) - (this.getTimezoneOffset()/1440) + 2440587.5);
}
var today = new Date();
var julian = today.getJulian();
Y1=julian;

For More Information:

• iDashboards Builder Manual 14 Analytics
• JavaScript Expression Help

Disclaimer: iDashboards Technical Support Engineers are not Data Analysts who know in depth SQL Queries or JavaScript Expressions. We often learn these skills on the job and have limited knowledge. We do our best to help you with your software in determining if: you are not leveraging the software in the best way for your data or you found a bug in the software, because we want to assist you in your success. If you have issues with in depth queries or expressions please contact iDashboards Support and know that it will take a bit of time to figure out what is necessary for this issue, and if necessary we will refer you to your Client Success Manager to schedule time with a Principal Product Engineer.

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.