Belleke
Well-Known Member
I have
Textbox1.Value = Format(Date, "dd/mm/yyyy")
and
Textbox2.Value = Format(DatePart("q", Textbox1.Value))
The result in textbox 2 is wrong, it uses the American date notation
example 02/05/2019 gives as result 1(uses 02 as month) but it should be 2 (5th month, second quarter)
How can I change that?
Thanks
Textbox1.Value = Format(Date, "dd/mm/yyyy")
and
Textbox2.Value = Format(DatePart("q", Textbox1.Value))
The result in textbox 2 is wrong, it uses the American date notation
example 02/05/2019 gives as result 1(uses 02 as month) but it should be 2 (5th month, second quarter)
How can I change that?
Thanks