Set Field Question...

[Protour Travel]

We have to generate monthly reports to the company regarding miles traveled and fuel purchased. These reports have to start at the beginning day of each month.

 

As I have it now, when you start a new month, the variable ($EndDate) is set to be the date field of the last record in the portal.

 

When the new month record opens up it has a starting date. Now it is set to SetField as $EndDate + 1.

 

This is fine if your last entry on the previous month as on the final day of that month. However, lets say a driver makes his last trip to Austin, TX on August 26th and this is where he makes his last monthly entry to the DB.

 

As of now, when he creates the new monthly record, the starting date is August 27th. The month needs to start on Sept 1st.

 

Is there a set field function that will read the variable and automatically set the new report start date to the first day of the next month?

[comment]

Well, yes - but if the driver hasn't made any trips in the last month, you will have the same problem.