Change inputed manually date to first day of month

[jaryszek]

Hi,



my userform looks like below:



In the bottom you can see a subform where users can add manually Correction_Date (Data_Korekty).
Users can choose for example date 2017-07-13 but i want to have only 07-2017 as the result.

I achevied it by changing format in my table field to "mm-yyyy".

But true date there is a 2017-07-13 - i want to do change it for 2017-07-01.

So user chooses 2017-07-13 and the date should be saved as 2017-07-01 but looks like 2017-07.
Or maybe this process can be done without days ? Only month and year?

thank you for your help!
Jacek Antek

[ranman256]

just because you set the format does not change it to the 1st day. It only shows you mm/yy

you can have a hidden field txt1Mo , that converts the date they enter.
then have the hidden field connect to the table.
txt1Mo.ControlSource
=year(txtDate) & "/" & month(txtDate) & "/1"

[jaryszek]

Thank you ranman256 it is working like a charm !

Best wishes,
Jacek