Simple, but I cannot find it

[Inky Phil]

Hi everyone

I am presetting some dates as an assumption that the user wants a report for the previous month. I intend to set a global (via script) to the 1st date of the month previous to the current date. I want to set another global to the last date of the month previous to the current date.

I know this must be relatively simple but I cannot for the life of me work it out nor can I find it in the forum. Can anyone help please?

Many thanks in advance

Phil.

[IdealData]

The last day of a month is also the day before the first day of the following month.

[Inky Phil]

Sorted thank you.

Philip.

[Fitch]

Let FileMaker do the math. Where yourDate = Get(CurrentDate) or some other date, this will give you the last day of the previous month:

Date( Month( yourDate ) ; 0 ; Year( yourDate ) )

[Inky Phil]

Thank you Fitch