HA
06/19/2025, 3:18 PMCeligo AI
06/19/2025, 3:18 PMAI generated answer (using internal Slack threads):In NetSuite, the
createddate
field can be used to get the date and time when a record was created. However, the way to retrieve this information can vary depending on the context.
1. In a Saved Search: You can use the System Notes fields. Under the join fields, find "System Notes : Field" and set it to "Date Created". In the Results, under the join fields, use "System Notes : Date".
2. On a Form: If you want to display the createddate
on a form, you might need to create a new field with a default formula like {createddate}
. However, this might not always be visible on the form customization options.
3. In SuiteScript: If you're using SuiteScript, you can use nlapiGetFieldValue('createddate')
to get both the date and time.
4. In N/Query: If you're using N/Query, you can use SELECT createddate FROM transaction
to get the date, but it might not include the time. To get the time as well, you can use the TO_CHAR
function to format the date and time as you want.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
06/19/2025, 3:19 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823437035
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820402563
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.813008189
Celigo AI
06/19/2025, 3:19 PM