Join Slack
Powered by
wondering if there is a function for getting the m...
# general
n
Neha N
04/06/2022, 8:53 PM
wondering if there is a function for getting the month from a date using suiteql?
c
chris
04/06/2022, 9:04 PM
Yes, it's documented in the functions in the dataset formula builder.
n
Neha N
04/06/2022, 9:05 PM
you mean ADD_MONTHS ?
Neha N
04/06/2022, 9:05 PM
is there anything other than that?
m
michoel
04/07/2022, 12:12 AM
https://database.guide/how-to-get-the-month-name-from-a-date-in-oracle/
n
Neha N
04/07/2022, 12:14 AM
Thank you, are you aware of a function similar to DATEDIFF in suiteql?
m
michoel
04/07/2022, 12:15 AM
Just subtract the two dates
2
Views
Open in Slack
Previous
Next