I have the following formula but keep getting error for 'Then missing'. Please advise where to insert 'Then'
If ({Command.DATA_TYPE_CD}="D" );
FormatDate(ToDate(FormatNumber({Command.BEFORE_VALUE_NO};"000000");"MMddyy"); "dd-MMM-yyyy")...
New to Query Builder and trying to see how it will help us but when we try to query for example: long running reports or reports using specific folder, always get runtime error.
Are there specific indexes we should use, etc?
Examples of queries:
select si_name,
si_parent_folder_cuid...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.