Is there way to get only month or year from trans...
# suiteanalyticsm
megha
10/31/2019, 4:40 PMIs there way to get only month or year from transaction date in saved search results?
a
al3xicon
10/31/2019, 4:41 PMyes
al3xicon
10/31/2019, 4:41 PMmessage has been deleted
al3xicon
10/31/2019, 4:42 PMvia the function list in results, or you can also use a formula
g
Gregory Jones
10/31/2019, 4:42 PMsome good examples here https://www.abaci-us.com/netsuite-to-date-to-char-date-functions/
m
megha
10/31/2019, 4:59 PMThanks👍
g
George McMullen
10/31/2019, 10:11 PMYou can also use a TRUNC date formula, which would still return a whole date, but with the day/month set to the first. For example if {trandate} were Jun 15, 1999 -> TRUNC({trandate},'YEAR'} would return Jan 1, 1999. (I may have the exact syntax off. Could be YYYY and use double quotes). It's helpful when doing comparisons.
👍 1
39 Views