Á

Álvaro Moura

Last updated on Jul 6, 2026

Scriptcase provides a very useful macro for manipulating dates, which is a very laborious process, however with the use of the sc_date macro (Increments and Decrement Dates), it is much simpler, example:

sc_date (Date, format, operator, D, M, A)

date - Date field containing the date to be modified
format - Formatting in which the date field is
operator - "" for increment and "-" for decrement
D - Number of days to increase or decrease
M - Number of months to increase or decrease
A - Number of years to increase or decrease

E.g.1:

{datanasc} = sc_data ({datanasc}, "dd/mm/aaaa", " ", 30, 0, 0);

E.g.2:

$nova_data = sc_data ({datanasc}, "aaaa-mm-dd", "-", 15, 3, 2);

E.g.3:

{dt_inclusao} = sc_data (date('Ymd'), "aaaammdd", "-", 0, 1, 1);

Tip:

To make sure the date format, before using the function, put a command in its formula:
echo "form_data =". {date field name};

Run the application and see the correct format.