Changing format of output date

[ad_1]

Hello @limarob

Thank you very much for using our plugin.

DATETIMESUM operation returns a date object, and you must use the GETDATETIMESTRING operation to transform it into a text with date format as follows:

GETDATETIMESTRING(DATETIMESUM(fieldname3, 'dd/mm/yyyy', -49, 'd'), 'dd/mm/yyyy')

However, if fieldname3 is a date field, the process is simpler:

CDATE(fieldname3-49, 'dd/mm/yyyy')

Best regards.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer