Skip to main content
Inspiring
June 19, 2017
Question

Get date format from field

  • June 19, 2017
  • 4 replies
  • 1889 views

I want to be able to get a date object form a date field. I am aware I can do this:

var value = getField("date").value;

var date = util.scand("yyyy-mm-dd", sDate);

But this requires that I know what the date format is.

I want to be able to get a date object from a date fields without having to bake the formatting string into the script.

Any help would be appreciated

This topic has been closed for replies.

4 replies

McShamanAuthor
Inspiring
June 19, 2017

the only thing that seems to differentiate a date picker field and a text field is the built in date format option.

Is there a way that I could call the built in date formatting action from within a custom format script allowing me to specify the format while still displaying the field as a date picker?

Joel Geraci
Community Expert
Community Expert
June 20, 2017

You'll need to create two separate fields one with the custom format and one with the date format. Then you just have them update each other via a script.

Karl Heinz  Kremer
Community Expert
Community Expert
June 19, 2017

You can use the JavaScript Date object to parse your date string:

var sDate = getField("date").value; 

var newDate = new Date(Date.parse(sDate));

You can find details about how this works here: Date.parse() - JavaScript | MDN

Bernd Alheit
Community Expert
Community Expert
June 19, 2017

You can try:

var date = new Date(Date.parse(sDate));

try67
Community Expert
Community Expert
June 19, 2017

Without knowing the format any parsing method is useless. How would it know if "01-03-16" is January 3rd 2016, or March 1st 2016, or March 16th 2001 or March 16th 1901, etc.?

Bernd Alheit
Community Expert
Community Expert
June 19, 2017

It works for the format yyyy-mm-dd.

try67
Community Expert
Community Expert
June 19, 2017

Not possible.