Days between two dates

  • Resolved PB

    (@ohtusabes)


    1 year, 1 month ago

    Hi. I′m doing my best but I failed. I want to calculate the days betweens two dates, but I can′t find the way. Could you give me some tips? Thanks in advance. Amazing plugin.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter PB

    (@ohtusabes)

    I am using for example: GETDATETIMESTRING(fieldname6,dd-mm-yyyy), where fieldname6 is a date time field, and I have no results. I think I need the strings before using DATEDIFF. No matter how, I didnt′t reach any results.

    Plugin Author codepeople

    (@codepeople)

    Hello @ohtusabes

    If you have two date fields, for example, fieldname1 and fieldname2, the process is as simple as:

    ABS(fieldname1-fieldname2)

    If you use different controls than the date for fieldname1 and fieldname2, the equation can be implemented as follows:

    DATEDIFF(fieldname1, fieldname2, 'dd-mm-yyyy', 'd')['days']

    Best regards.

    Thread Starter PB

    (@ohtusabes)

    Yes, it worked perfectly. Thank you so much. Is there a way to change the language of the date field? Thank you, again.

    Plugin Author codepeople

    (@codepeople)

    Hello @ohtusabes

    Yes, you can. Please read the following entry in the plugin FAQ:

    https://cff.dwbooster.com/faq#q221

    Best regards.

    Thread Starter PB

    (@ohtusabes)

    That’s great. I saw the code is for translating to French. Could I change the data to Spanish? Thank you for all your help.

    Plugin Author codepeople

    (@codepeople)

    Hello @ohtusabes

    The code is only an example. You can translate the text to the preferred language.

    Best regards.

    Thread Starter PB

    (@ohtusabes)

    Thank you. Great plugin and impressive support.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Days between two dates’ is closed to new replies.

Tags