How can I convert a Alpha value (A10: dd.mm.yyyy) to a Date Value???
It's necesary because I Need to filter my Report with Dashboard Text Prompt. I want to FIlter the Date with GE or LE.
Just works with I8YYMD.
Thanks!!!This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8.1.05 Windows, All Outputs
October 22, 2018, 10:57 AM
MReeder
DATECVT(date, 'in_format', output)
WebFOCUS 8.2.02M Windows Server/8.2.02M All Outputs
October 22, 2018, 11:01 AM
BabakNYC
DEFINE FILE CAR
DATE_A10/A10 WITH CAR = '22.10.2018';
DATE_A8DMYY/A8DMYY=EDIT(DATE_A10,'99$99$9999');
DATE_I8DMYY/I8DMYY=EDIT(DATE_A8DMYY);
END
TABLE FILE CAR
PRINT DATE_A10 DATE_A8DMYY DATE_I8DMYY
BY COUNTRY
BY CAR
END