Date formatting...

[Protour Travel]

One of my reports uses a start date formatted as MM/DD/YYYY. I have written another script for a new report and here is what I need to happen;

 

On the present report, say the start date is 11/01/2012 when I select the new report button I want to update the date to the same day (01) of the next month (12/01/2012).

 

As you can see, I am now having to manually enter the date in order for the script to run correctly.

 

Thanks much...

[dansmith65]

Date (
    Month ( $date ) + 1 ;
    Day ( $date ) ;
    Year ( $date )
)