weekday function

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

    (@codepeople)

    Hello @rphrus

    The Developer and Platinum versions of the plugin are distributed with the Date/Time operations module. This module includes the WEEKDAY(x,y) operation, that returns a number from 1 to 7, 1 for Sunday to 7 for Saturday.

    So, if you want the result with the day name, you can implement the equation as follows:

    ({1:'Sunday', 2:'Monday', 3:'Tuesday', 4:'Wednesday', 5:'Thursday', 6:'Friday', 7:'Saturday'})[WEEKDAY(TODAY())]

    Best regards.

    Thread Starter rphrus

    (@rphrus)

    Let’s put an example; field1 date picker, field2 enter number, field3 result of field1+field2. How would you have it shows in the result with in Day of week, month, day, year?

    Thanks

    Plugin Author codepeople

    (@codepeople)

    Hello @rphrus

    You should use the CDATE operation, where the second parameter would be the format of the output, as follows:

    
CDATE(fieldname1+fieldname2, 'dd/mm/yyyy')

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘weekday function’ is closed to new replies.