Hello guys!
How to format a field in the form to insert a date in the table as a month and a year. Let's say:
01.2018
Hello guys!
How to format a field in the form to insert a date in the table as a month and a year. Let's say:
01.2018
I did not understand you well!
I have this situation. In form I have two dates, which are transferred to the table.
In the column Date 1 are showing well on date 20.06.2018, but we need in Date 2 column to appear in form 05.2018 (should be month back).
This looks like somehow. How to do this?
OK - I was describing formatting for VBA code - ignore that
Whilst Text4 is selected, select the Format tab on the property sheet.
Then in the Format row (top line) enter mm\.yyyy
FYI the \ is used to ensure the following character appears as written - in this case a full stop e.g. 05.2018
Bravo master. This is working. Thank you!OK - I was describing formatting for VBA code - ignore that
Whilst Text4 is selected, select the Format tab on the property sheet.
Then in the Format row (top line) enter mm\.yyyy
FYI the \ is used to ensure the following character appears as written - in this case a full stop e.g. 05.2018