My fellow WebFocus-Users,

I am seraching for a way to convert a DMYY field in order to recieve info in which calendar week (plus year) the date fell. So what i need is a field with the format CW'/'YY.
Anyone any idea? Realy apreciate it.
Further info: if helpful my DMYY-field is also available as an integer-field.

Thanks and best regards,

Florian

This message has been edited. Last edited by: Kerry,

You may wish to consider the function HYYWD; it returns the year and week number from a date-time value.
It is up to you to make sure that the argument you pass to it is a date-time value.

You might have to 'tweak' this to get exactly what you want, but I would find the number of days siince 1/1, divide by 7 and concatenate that value onto the year portion of field.

 
DEFINE FILE CAR
   FIRSTDAY/DMYY WITH COUNTRY = 01012012;
   FIRST_DAY/YYMD = FIRSTDAY;
   YOUR_FIELD/DMYY WITH COUNTRY = &DMYY ;
	LAST_DATE/YYMD = YOUR_FIELD;
   DAYS/I5 = DATEDIF(FIRST_DAY, LAST_DATE, 'D');
   WEEKS/I2 = DAYS/7;
   WEEK_ALPHA/A2 = EDIT(WEEKS);
   DATE_TXT/A8 = DATECVT(LAST_DATE, 'YYMD', 'A8YYMD') ;
   FINAL_ANSWER/A8 = WEEK_ALPHA || '/' || EDIT(DATE_TXT, '9999');
END
 

Not sure if this gives you the correct week number but...

TABLE FILE TRADES
PRINT DATE_OF_TRADE
COMPUTE YEAR/YY = DATE_OF_TRADE ;
COMPUTE WEEK/W = DATE_OF_TRADE ;
COMPUTE CWYY/A7 = EDIT(WEEK) | '/' | EDIT(YEAR) ;
WHERE RECORDLIMIT EQ 100
END

quote:

Originally posted by Waz:
Not sure if this gives you the correct week number but...

TABLE FILE TRADES
PRINT DATE_OF_TRADE
COMPUTE YEAR/YY = DATE_OF_TRADE ;
COMPUTE WEEK/W = DATE_OF_TRADE ;
COMPUTE CWYY/A7 = EDIT(WEEK) | '/' | EDIT(YEAR) ;
WHERE RECORDLIMIT EQ 100
END

You'll want to set the WEEKFIRST parameter to either Sunday (1) or Monday (2), depending on what standard your week numbering needs to follow. The default appears to be 6 (Saturday), which makes me wonder in which country the week starts at Saturday?!?

quote:

rfbowley

Thank u rfbowley. Genius.

quote:

Originally posted by rfbowley:
You might have to 'tweak' this to get exactly what you want, but I would find the number of days siince 1/1, divide by 7 and concatenate that value onto the year portion of field.

 
DEFINE FILE CAR
   FIRSTDAY/DMYY WITH COUNTRY = 01012012;
   FIRST_DAY/YYMD = FIRSTDAY;
   YOUR_FIELD/DMYY WITH COUNTRY = &DMYY ;
	LAST_DATE/YYMD = YOUR_FIELD;
   DAYS/I5 = DATEDIF(FIRST_DAY, LAST_DATE, 'D');
   WEEKS/I2 = DAYS/7;
   WEEK_ALPHA/A2 = EDIT(WEEKS);
   DATE_TXT/A8 = DATECVT(LAST_DATE, 'YYMD', 'A8YYMD') ;
   FINAL_ANSWER/A8 = WEEK_ALPHA || '/' || EDIT(DATE_TXT, '9999');
END
 

Ah, if it were that simple! In countries that follow the ISO-8601 standard for week numbering, the first of Januari can fall in week 1 or 52 or 53, depending on whether that date is before or after Wednesday and how many weeks the previous year had.

So what would you suggest?
I'm really bad at this.

Valid values are ISO1-ISO7

  
SET WEEKFIRST = ISO2 
TABLE FILE EMPLOYEE
PRINT LAST_NAME FIRST_NAME 
  COMPUTE NEWSAL/D12.2M = CURR_SAL + (0.5 * CURR_SAL);
  COMPUTE DATE1/HYYMDIA = DT(20050101 09:00AM);
  COMPUTE DATE2/DMYY    = HDATE(DATE1, 'DMYY');
  COMPUTE ISODATE/A10   = HYYWD(DATE1, 'A10');
END

Well Tom, it appears that YOU can teach an old dog a new trick :-)

Thanks, I learned something new.

Hi Robert,

Welcome, BUT, I'm probably the 'old dog'!

Just want to make sure you installed the 64 bit version of WF and not the 32 bit version. I made that mistake on Windows and it did not work. Installed the 64 bit version of WF and everything worked just fine.