Choose Language Hide Translation Bar
Highlighted
Sully
Level III

Create Value for First Day of the Month

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Create Value for First Day of the Month

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" );
Learn it once, use it forever!

View solution in original post

2 REPLIES 2
Highlighted

Re: Create Value for First Day of the Month

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" );
Learn it once, use it forever!

View solution in original post

Highlighted
Sully
Level III

Re: Create Value for First Day of the Month

Thank You Mark!

 

That worked perfectly!

Article Labels

    There are no labels assigned to this post.