Get the week number of the year

  • Resolved mevabien22

    (@mevabien22)


    5 years, 3 months ago

    Hi,

    I want to get the week number of the year to which a certain day of the year belongs

    Field Type: Date Time
    filedname4 = 22/9/19

    I have tried this:
    Field Type: Calculated Field
    WEEKNUM(fieldname4, 'dd / mm / yyyy')

    which should return the number: 38

    but it does not work,

    what am i doing wrong?

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @mevabien22

    The WEEKNUM operation is included in the “Date/Time” operations module, distributed with the Developer and Platinum versions of the plugin (https://cff.dwbooster.com/documentation#datetime-module)

    What version of the plugin do you have installed on your website? Which is the URL to the page where the form is inserted?

    Best regards.

    Thread Starter mevabien22

    (@mevabien22)

    I have the free version, that’s why it doesn’t work then …
    I will see how to solve it in another way.
    Thank you.

    Plugin Author codepeople

    (@codepeople)

    Hello @mevabien22

    As a tip: if the fieldname1 is a date/time field and you want get the corresponding date/time javascript object, use the following piece of code as part of your equation:

    
var obj = new Date(fieldname1*86400000);

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Get the week number of the year’ is closed to new replies.