Database is in oracle, my machine has odbc 32 bits configured with the name PPM and I've created a script but need assistance formatting a calculated field:
LIB CONNECT TO [PPM];
SQL Select NP.BUSINESS, NP.PLATFORM, NP.CATEGORY,
CASE WHEN IMPLE IS not NULL THEN IMPLE
WHEN CONTRACT IS not NULL THEN CONTRACT
WHEN ANALYSIS IS not NULL THEN ANALYSIS
ELSE IDEA END AS REALDATE,
date(floor("REALDATE",'MM.YYYY') as "REALDATE2"
I found a way around after long hours of trying:
DATE#(DATE(Date#([REALDATE], 'MM-YYYY'), 'MMM/YYYY'), 'MMM/YYYY')
Could not format the field inside the script but this does the trick
Thanks for the help!