what function can show me the date created with ti...
# ask-stanley-ai
h
what function can show me the date created with time?
c
AI 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. ******
Slack 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
Please provide your feedback on this answer.