Display Calendar Weeks in Fast Report! how?

edited 8:51AM in FastReport VCL 5
Hi,

i wonder why there is no function which returns the Calendar Week Value for a certain Date-field?

At this point id like to know how to bypass this Problem?
Id be grateful for a working code snippet for that.



Best Regards

Comments

  • edited 8:51AM
    no1 got a clue for me >?
  • PolomintPolomint Australia
    edited 8:51AM
    Could you not use Delphi's System.DateUtils.WeekOf?
  • edited March 2016
    Actually i cant since im not that experienced in Delphi it self...

    How can i use this System.DateUtils.WeekOf in a simple Memo Field???
    ... And if thats not possible, how can i do this on code side?




    For better understanding:
    I just want a certain DateTime Datafield to return a Simple Calender Week for the the current Year...

    Thats a pretty basic function needed in a lot financial/business situations... i tough that such a common thing must be available in the given functions-set of Fast Report...? This is the very last thing missing in my report and i really want to finish this D: ...
  • gpigpi
    edited 8:51AM
    See a Developer's manual https://www.fast-report.com/en/download/public_files/214/ how to create custom functions for FR
  • edited 8:51AM
    iif i were that skilled in writing my own functions yet, i would't have to ask.


    so there is no implemented function in FR for that?

  • gpigpi
    edited 8:51AM
    wrote:
    so there is no implemented function in FR for that?
    Yes, there is no such function in the FR's script
    wrote:
    iif i were that skilled in writing my own functions yet, i would't have to ask
    Try to read Developer's manual
  • edited March 2016
    Well then, here is my solution.
    I think other people may take advantage of that someday [img]style_emoticons/<#EMO_DIR#>/biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" /> ... Memo Field:[/img]
    [Trunc((<frxDBDataset1."LIEFERTERMIN">-(EncodeDate(YearOf(<frxDBDataset1."LIEFERTERMIN">-(<frxDBDataset1."LIEFERTERMIN">-2) MOD 7+3),1,1)+((<frxDBDataset1."LIEFERTERMIN">-2) MOD 7-9)-1))/7)]
    
  • PolomintPolomint Australia
    edited 8:51AM
    Hmmmm. Not sure that code will produce an ISO 8601 standard value...

    Wikipedia on ISO 8601 Week Dates

Leave a Comment