HI,
How can I convert my period number 5 0 = 11501 (CYYMM) into a date (without days) ?
How can I convert my period number 5 0 = 11501 (CYYMM) into a date (without days) ?
#include <stdio.h> #include <stdlib.h> #include <string.h> #include <qusec.h> #include <qwccvtdt.h> typedef struct EC_x { Qus_EC_t EC; char Exception_Data[48]; }EC_t; int main(int argc,char *argv[]) { char Buf[18]; EC_t Error_Code; Error_Code.EC.Bytes_Provided = sizeof(Error_Code); QWCCVTDT("*YMD ", "1150101000000000", "*YYMD ", Buf, &Error_Code); printf("%.18s\n",Buf); exit(0); }
RealDate = %Date(YourNumdate * 100 + 1: *CYMD);
Select Date(Digits(Dec(YourDate50 * 100000000 + 1000000) + 19000000000000, 14, 0), Date(Digits(Dec(YourDate50 + 190000, 6, 0)) concat '01000000') From yourTable
Comment