I'm still new to Sisense, but have a question regarding manual input query. I need to identify transactions that posted today. I can manually add the table and convert the date field, but it's not working when I try to use the same formula in the where statement of the manual query. The date is a Julian Date 2020113 and appears as Float when you add the table without using the manual query.
The error say required field why cannot be null. I've check field name, extra spaces and commas, but nothing is working.
SELECT DHACCT,DHAMT,DHDATE FROM xxxxxxxxxx WHERE ToDateTime(CreateDate(ToInt(Substring(ToString(GetYear(CreateDate(([DHDATE]/1000),1,1))),1,4)),GetMonth(AddDays(CreateDate(2016,1,1),Floor(mod([DHDATE],1000)))),GetDay(AddDays(CreateDate(2016,1,1),Floor(mod([DHDATE],1000)))))) = ToDateTime(Now())
Please sign in to leave a comment.