I am using the below code and the data I am getting is throwing an error in a date field. basically I want to get the week start date in MM/DD/YYYY format.

function startOfWeek()
        {
            current_date =  new Date();
            var diff = current_date.getDate()-current_date.getDay()+(current_date.getDay() === 0 ? -6 : 1);
            var date = new Date(current_date.setDate(diff));
            var WSD = format.format({
                value: date,
                type: format.Type.DATE
            });
            return WSD;
        }

and even though the log.debug shows a string in MM/DD/YYYY format its still throwing an error. Have tried multiple snippets for the same task and none of them is returning a value that can be put in the date field of the record.

use setValue with a Date object

time zone is not the issue right now. By the way I used setText and it still throwed an error. I am passing the date in the date field.

the parameters to Record.setText are not the same as Record.setValue

yeah my bad, thank you. one last question If I wanted to use setValue instead of setText Is there a way to convert the string back to a date object but keep the date format in MM/DD/YYYY.

wrong way of thinking about dates

true I guess, its just when we used to print the date it gives us a datetime object Instead of the value in milliseconds. so I thought we could change the formatting. anyway thank you.

if you wanted to use setValue, you would simple use

date

or honestly

current_date

date is giving me start of the week for today its same. as currently in UTC today is monday. tomorrow both will be different. current_date will be of tuesday. while date will show as monday

im not saying that either is really correct due to my timezone warning