I'm using a formula in a workbook to show the numb...
# suiteanalyticsz
zaanton
01/23/2020, 6:38 PMI'm using a formula in a workbook to show the number of days since today. Is there a function I can use to get today's date and another function to subtract a date field value from another? Would I better off using conversion like TO_NUMBER?
z
zach
01/23/2020, 6:38 PMSYSDATE is the typical function used to get today's date
z
zaanton
01/23/2020, 6:42 PMUnfortunately I don't think SYSDATE is available here:
zaanton
01/23/2020, 6:48 PMIt looks like I can use CURRENT_DATE for getting today's date, I must have missed it while searching. I still can't find a good way to subtract the two dates via formula.
zaanton
01/23/2020, 6:54 PMApparently DATE is not supported either, and CURERNT_DATE returns a datetime instead of a date value. How do I convert the value outside of using some crazy TO_CHAR convert + parsing?
zaanton
01/23/2020, 6:56 PMI found out there is a specific cast that is allowed for converting Datetime into Date - CAST_TO_DATE. CAST is not available but this helps haha.
zaanton
01/23/2020, 7:00 PMOkay I think I got it:
ROUND(CAST_TO_DATE((CURRENT_DATE)) -{custentity_last_tran_date})
I want to convert this to an integer output though, looking into it.
g
Gregory Jones
01/23/2020, 7:03 PMIf only workbooks was literally just the ability to pivot a saved search.
❤️ 1
z
zaanton
01/23/2020, 7:08 PMI gave up on the float -> int convert and I'm just going to convert the value into a string and substring before the '.'. I'll look into it more later.
2 Views