How can I return the current day of the month as a...
# suiteanalyticsb
Brian
06/08/2023, 2:28 PMHow can I return the current day of the month as a single number in a search? For example, today would just be '8'.
s
scottvonduhn
06/08/2023, 2:36 PMFormula (Numeric) result field, with formula:
EXTRACT(DAY FROM {today})c
CD
06/08/2023, 2:36 PMTO_CHAR(SYSDATE,'DD')
CD
06/08/2023, 2:37 PMMillions of ways of doing this one 😉
✔️ 1
b
Brian
06/08/2023, 2:37 PMAwesome, thank you!
s
scottvonduhn
06/08/2023, 2:39 PMyou can either use {today} or SYSDATE for either as well. Just know that SYSDATE uses the current date/time of the NetSuite backend database, while {today} is generated by the NetSuite application servers, so there may be differences, based on timezone.
b
Brian
06/08/2023, 2:40 PMTO_CHAR({today},'DD') is working as expected
Brian
06/08/2023, 2:44 PMWhich I think will match with my instance's time zone.
Brian
06/08/2023, 2:44 PMbut, how could I get the day of the YEAR?
s
scottvonduhn
06/08/2023, 2:47 PMsubtly different, but
TO_CHAR({today},'DDD')👍 2
b
Brian
06/08/2023, 2:50 PMPerfect, thanks for your help.
8 Views