Hello @nakashu99
Thank you very much for using our plugin. The CDATE operation includes a second parameter to decide the output date format. For example, assuming the date field is the fieldname1, you can implement the equation in the calculated field as follows:
CDATE(fieldname1, 'dd/mm/yyyy');
or any other combination of the date components:
CDATE(fieldname1, 'mm-dd-yyyy');
If you want to increase the fieldname1 value in some days, for example, in a week, the code would be basically:
CDATE(fieldname1+7, 'mm-dd-yyyy');
Or, you can use the DATETIMESUM operations in the “Date/Time Operations” module (https://cff.dwbooster.com/documentation#datetime-module):
GETDATETIMESTRING(DATETIMESUM(fieldname1, 'yyyy/mm/dd', 7, 'd'), 'yyyy/mm/dd')
Best regards.