Hi Clayton,

What database are you using, and what is the data type of the field as shown in the view?

Can you please show us the view field setup, and also the column format here in the report?

If you choose any other format , e.g. DD/MM/YYYY does it show the correct values?

Thanks,
David

It is Amazon Redshift, the field it is using is a DATE field. Here is the SQL:




I have a record for each month and a MonthBeginDate and MonthEndDate for the month. Formatting the MonthBeginDate works, but the MonthEndDate is having problems.

Here is the format in the view. Month1 has a Format of MMMM YYYY and Month2 has a format of MM/DD/YYYY. Notice how Month1 works for everything except December 2013 has December 2014. But Month2 is all messed up.

Hi Clayton,

Looks like this is a duplicate post.
I believe what you're after is covered in this post, see the last comment.

Please let me know how it all goes.

Regards,
David