Find First Date and last date in month

Purple_13s · ‎2022-11-04

Hello!

Many thanks in advance for your response...

I have created a field 'Dates' which is the load date for each of my files.

I want to be able to extract the first load date and last load date from each month.

I then want to be able to store the first and last load dates as a variable to use in a set expression for charts + other kpis.

AndyC · ‎2022-11-04

Not sure exactly what you are trying to do but have you looked at the on-line help?

There are examples of using the Group By in the load script...