This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Hi there! How can I create an initiail value...

Posted on 11-02-2018 05:00 PM
Aparicio_Pineyr
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Hi there!

How can I create an initiail value that show allways the first day of the month?

Eg: 01/01/2018

Thanks!

0 1 292
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Aleksi_Alkio
New Member
Reply posted on --/--/---- --:-- AM

How about CONCATENATE(MONTH(TODAY()),"/1/",YEAR(TODAY()))

0 Likes
Top Labels in this Space