This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

share an example and your last attempt at a formula?

im just trying different date formats, the input date format (string) looks like this 2019-03-16T23:04:33.000Z

TO_DATE({custrecord_celigo_ebay_listing_end_time},'YYYY-MM-DD')

`to_date(substr({custrecord_celigo_ebay_listing_end_time},1,10),'YYYY-MM-DD')`

alternatively - you could modify your input format to include all the extra things at the end, not sure what date/time coding that is so can't point you in right direction.

cool yea i was just trying to substring thing. it makes sense but didn't work. i think im gonna try and play with the input format from celigo

well, try other things first, maybe 0,10 instead of 1,10

Couldn't you just truncate it and call it good?

i need to do something like, if this date is 90 days in the past, do this, otherwise do this

have you tried doing portions of this in columns and building it up?

ive gotten portions of text values but can't seem to make any date formulas work yet

<https://stackoverflow.com/questions/20749352/how-to-insert-iso-8601-type-date-into-oracle-database>

just for the record, I ended up just creating a 2nd date field and adding a mapping from the source app (celigo) as a date data type instead of text, since I needed a second date field for additional logic anyway.