Hello, is it possible to get a formula in suiteana...
# generalp
Phillip
05/22/2023, 4:58 PMHello, is it possible to get a formula in suiteanalytics to get the first date of the current month?
a
AK47
05/22/2023, 5:27 PMThis will bring the first day of next month LAST_DAY(CURRENT_DATE)+1
AK47
05/22/2023, 5:29 PMLAST_DAY(ADD_MONTHS(CURRENT_DATE,-1))+1
AK47
05/22/2023, 5:29 PMthat should bring the first date of this month
p
Phillip
05/22/2023, 5:45 PMthanks
Phillip
05/22/2023, 5:45 PMit worked!
👍 1
m
michoel
05/23/2023, 12:24 AMOr
TRUNC(CURRENT_DATE, 'MM')✔️ 1
5 Views