how do I display the previous month

[nicolareina]

Hello forum I need to display the previous month in the text box do you have any solution? for example if today is 03/01/2023 I want to display December in the textbox.



THANKS

[moke123]

Look at the DateAdd(). https://www.techonthenet.com/access/...te/dateadd.php

[nicolareina]

you can insert the code in control source?? no query

[Welshgasman]

you can insert the code in control source?? no query

Why not just try it?, takes seconds, and not going to affect anything?

[moke123]

you can insert the code in control source?? no query

both query and control source'

control source would be

=DateAdd("m",-1,Date())

[mike60smart]

This will display "December"

=Format(DateAdd("m",-1,Date()),"mmmm")

[nicolareina]

thanks i resolve