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.
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.
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.
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.
