Skip to main content
V
VaibhavShinde16-Pearl
16-Pearl
April 7, 2021
Solved

Get Date (yyyy-MM-dd) in DateTime format

  • April 7, 2021
  • 1 reply
  • 11648 views

Hi ,

I am looking to display date in format yyyy-MM-dd , but returned type should be DateTime. 

var d=new Date();
// dateFormat(dateValue:DATETIME, dateFormat:STRING):STRING
var formattedDate = dateFormat(d, "yyyy-MM-dd");


// parseDate(stringDate:STRING, dateFormat:STRING):DATETIME
var dateValue = parseDate(formattedDate, "YYYY-MM-DD");

but its returning Date with Time. I need only YYYY-MM-DD.

 

Thanks

Best answer by c_lowy

@VaibhavShinde,

 

If your goal is to use that timestamp as input to filtering data, and because a DateTime object will always have the time component as stated before, I believe you will need to call a time range in your JavaScript service filtering the data. For example take your timestamp looking something like 2021-13-04 00:00:00.000 and from there create a time range from that time until 2021-13-04 23:59:59.000 and use that to filter your data.

1 reply

C
c_lowy16-Pearl
16-Pearl
April 7, 2021

Hi @VaibhavShinde,

 

A JavaScript Date object will always have a time component and so does the ThingWorx DateTime format I believe. Depending on your intent could you consider formatting the Date at mashup level ? When displaying a date in a widget like DateTime or Value Display you can format it the way you want at runtime.

V
VaibhavShinde16-PearlAuthor
16-Pearl
April 7, 2021

Hi @c_lowy ,

 

Thanks for reply, I am looking to fetch records for that day( irrespective of time) . consider i have table with "datetime" column so it stores in format 'yyyy-MM-dd hh:mm:ss'.

now i want to fetch all records for the day (Current date).

Hope you got my requirement.

 

Thanks

C
c_lowy16-PearlAnswer
16-Pearl
April 13, 2021

@VaibhavShinde,

 

If your goal is to use that timestamp as input to filtering data, and because a DateTime object will always have the time component as stated before, I believe you will need to call a time range in your JavaScript service filtering the data. For example take your timestamp looking something like 2021-13-04 00:00:00.000 and from there create a time range from that time until 2021-13-04 23:59:59.000 and use that to filter your data.

Terms & ConditionsCookie settingsAccessibility statement