SELECT * FROM Account need to get the createddate along with it

AI generated answer (using internal Slack threads):

To get the

createddate

along with the time in a transaction using N/Query, you can use the

TO_CHAR

function to format the date and time as per your requirement. Here is an example:

sql
SELECT TO_CHAR(createddate, 'MM/DD/YYYY HH24:MI:SS') FROM transaction

This will return the

createddate

in the format 'MM/DD/YYYY HH24MISS' (Month/Day/Year HourMinuteSecond in 24-hour format). As for displaying an item record's

createddate

field on its form, it seems that this field is not directly available for customization on the item's form. However, you can create a new field with a default formula like

{createddate}

. This should display the

createddate

on the item's form. For the account's

createddate

, you can create a "Transaction" Search, use "Account" as the criteria to pick the account, then use "Date before" as the criteria for the date in question. For "Results", show "Account" (Grouped) and "Amount" (Sum). However, as your data grows, this type of search may run slow. A recommended alternative is to run the canned Trial Balance Report (Reports>Financial>Trial Balance). To run it by date instead of period, you'll have to change your Report by Period User Preference (Home>Set Preferences>Analytics tab) to Never. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******