Sc_date() macro

Scriptcase 9
#1

I’m trying to use this code

{EndDate} = sc_date({StartDate}, “mm/dd/YYYY”, “+”, 0, 0, 1);

My {StartDdate} is: 07/01/2020
to add 1 year to the date but I end up with date that shows up like this: 2/2007/1

I tried differend mm/dd/YYYY patterns but nothing seem to work
any ideas why this is not working ?

#2

What is wrong with this macro ?
Here is another example that doesn’t work for me:

The {StartDate} on the Form is: 07/01/2020
I’m trying to add 1 month and the result in {ExpDate} is: 201/20/0

{ExpDate} = sc_date({StartDate}, “mm/dd/yyyy”, “+”, 0, 1, 0);

ANY IDEA WHAT IS GOING ON HERE ?

#3

Here’s a snippet of code that I’ve used to create recurring jobs (uncomment the echo statements to see what you’ve got)

//make recurring
$begin_date = date(“Y-m-d”, strtotime({start_date}));

if ({interval} == ‘W’) {
$x = 1;
$frequency = 0 ;
$interval = 7 ;
while($x <= {duration}) {

//Initializing the parameters to be add
$add_days = $frequency; //adding 7 days
$add_months = 0; //adding nothing to months
$add_years = 0; //adding nothing to years
$requested_on = sc_date($begin_date, ‘yyyy-mm-dd’, ‘+’, $add_days, $add_months, $add_years);
$frequency = $interval * $x ;
// echo $requested_on.’
’ ;
// echo "$frequency The number is: $x
";

#4

This line has to be replaced with double quotes, or it will not work:
$requested_on = sc_date($begin_date, “yyyy-mm-dd”, “+”, $add_days, $add_months, $add_years);