Good Morning Everyone.
I am trying to get a date minus 6 months of Current date but the date must be the begin day of the month.
Here is what I have
=Cstr(Month(Dateadd("m", -6, now())))& "/1/"& YEAR(Dateadd("m", -6, now()))
If I run this on preview. I get the property Default Value of...