Would someone be able to tell me how I can find/create a value for the first day of the current month?
I have been looking through discussions and attempting different formulas with no success.
Go to Solution
You could derived a formula from the elements illustrated here:
Names Default to Here( 1 );
now = Today();
month = Month( now );
year = Year( now );
first day = Date DMY( 1, month, year );
Format( first day, "MDY" );
View solution in original post
Thank You Mark!
That worked perfectly!
There are no labels assigned to this post.