Display Month and Year from date field
I have a generic date field. I'd like it to display MONTH YYYY i.e. JULY 2016. Tweaking the date field i am able to get close (JULY 1 2016) but the date still shows 1. Is there a formula that can ...
Forum Discussion
This formula worked perfectly for me. I do have a question... If I'm working a month behind, how can I modify this formula so that instead of the $MMYYYY showing up as the same month as the [My Date Field], it shows up as a month prior to the [My Date Field]?
------------------------------
Christine Christine
------------------------------
------------------------------
Christine Christine
------------------------------
I believe the best way would be to adjust the DateWords variable to be 1 month behind to begin with.
var date DateWords = AdjustMonth([My Date Field],-1);
That should do it for you. I tested it on one date myself and it did work.
var date DateWords = AdjustMonth([My Date Field],-1);
That should do it for you. I tested it on one date myself and it did work.
- This worked perfectly! Thanks!
------Original Message------
I believe the best way would be to adjust the DateWords variable to be 1 month behind to begin with.
var date DateWords = AdjustMonth([My Date Field],-1);
That should do it for you. I tested it on one date myself and it did work.