Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Apr 29, 2022

Conditional Format form - between date and 30 days

Hello Experts,   I have a form in datasheet view. I need to conditional format txtDate for any records in the current month.  Its a little tricky since if there is not a record with the current mo...
access
  • arnel_gp's avatar
    arnel_gp
    Apr 30, 2022

    you can simplify your Criteria:

    [txtDate] Between DateSerial(Year(Date()), Month(Date()), 1) And DateAdd("d",30,Date())

     

    Note i remove the equal (=) symbol.

arnel_gp's avatar
arnel_gp
Steel Contributor
Apr 30, 2022

you can simplify your Criteria:

[txtDate] Between DateSerial(Year(Date()), Month(Date()), 1) And DateAdd("d",30,Date())

 

Note i remove the equal (=) symbol.

  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Apr 30, 2022

    arnel_gp 

    Hi Arnel, it works!  thank you so much.  

    Below is the output (it correctly highlights the next record in the next month since there are no records in April). thanks again for the help. 

     

     

Resources