We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

How to format my Date Field to "MM/dd/yyyy" string.

Closed

I have set data type of Date Column to { “type”: “date string” } which returns the date in “dd/MM/yyyy” but I need the date formate “MM/dd/yyyy”. How to achieve it? Please assist. 

2 answers

WebDataRocks Team WebDataRocks April 23, 2020

Hello,
 
Thank you for reaching out to us.
 
The desired formatting for the date string data type can be achieved using the datePattern property of the options object.
 
It can be specified in the following way:

...
options: {
datePattern: "MM/dd/yyyy"
...
}

 
You are welcome to check out an example we have prepared for you.
 
More about the options object and its properties can be found in our documentation.
 
We hope it works for you.
Do not hesitate to contact us in case additional questions occur.
 
Best regards,
WebDataRocks Team

manish April 23, 2020

Thank you so much. It worked.  

This question is now closed