How can i convert this 2023-07-05T000000-06:00 to 07/05/2023 in a script?

I've been using the momentjs library for dealing with dates. moment('2023-07-05T000000-06:00').format('MM/DD/YYYY')

its a trick question,

2023-07-05T00:00:00-06:00

is the same as

2023-07-04T23:00:00-07:00

@battk is correct, you can' t just ignore timezones... that said this will do what you want asked for.

const dateStr = '2023-07-05T00:00:00-06:00';
const dateArr = dateStr.split('T')[0].split('-');
const myStr = `${dateArr[1]}/${dateArr[2]}/${dateArr[0]}`;

how can i define moment library ? is it 'N/moment'

It's an external module, download moment.js here, place it in your suitescript folder, and use a relative path:

define(['./moment'], function(moment) {
})

moment is a 3rd party library https://momentjs.com/ you need to get the file in the file cabinet then reference the filepath in the define

got it thanks

it used to be the gold standard for javascript date libraries, however its now in maintenance mode

didn't the moment devs move to Luxon?

however the new alternatives use the internationalization related apis, which suitescript does not expose

Hey guys one more question. why am i getting this error? here is my code trying to set a date field "name":"INVALID_FLD_VALUE","message":"Invalid date value (must be M/D/YYYY)",

var ETA = JSON.parse(track_status_response.body).output.completeTrackResults[0].trackResults[0].dateAndTimes[0].dateTime 
   ETA = moment(ETA).format('l')
            
                   log.debug('ETA', ETA)

Are you getting the error using setValue?

yes

Try using setText()

setText doesnt give me an error but its not setting the field value

setValue uses a Date for date fields, setText uses a string for date field

The N/format module should help.

thanks for your help guys