Friday 14 November 2014

Current Year and Previous Year in Prompt

SELECT YEAR(CURRENT_DATE) FROM "Human Resources - Workforce Profile" 
UNION
SELECT YEAR(CURRENT_DATE)-1 FROM "Human Resources - Workforce Profile"























Thanks,

No comments:

Post a Comment

A fatal error occurred while processing the request. The server responded with: FOProcessor cannot run without a valid TMP directory. Please check if TMP directory exist and write enabled.

When attempting to export a Dashboard to Excel the following error message in sawlog is found: A fatal error occurred while processi...