Date in a Table- Removing the Time

Hi, I have a table that is connected to a dataset that is displaying results from a dropdown menu query and that is fine. One of the table fields is a date. How can I determine how the date is displayed? I just want for example 9/1/2018 - no time, no specific day. Would appreciate any help. Thanks.


Thanks. RESOLVED.

Hi,
This thread will be useful.
Feel free to consult if it doesn’t work for you.
Good luck!
Roi

Thanks Roi- that one was useful for date on a repeater - I have used that solution elsewhere. I found a post by Yisrael and he gave the code snippet for the solution on a table.

let date = new Date( “hereiputthevalueofmydatefield”);
let day = date.getDate();
let month = date.getMonth()+1;
let year = date.getFullYear(); let dateStr = year + “/” + month + “/” + day;
console.log(dateStr); // show result in the developers console

resolved- thanks all.

Hi Where did you put this ? in the page that holds the table? how did you link it to the data set? can you show me the full page code?

@fraser Heres an example of me using it:


Hope this helps…

@let-s-start-design thanks, this is a repeater. I have a table I want to change the date in. I have managed to do the repeater one but this table one I cant figure it out.

Did you get an answer? I have the same issue, but was given a code snippet which is for a text box, not a table.