Subform conditional formatting (1 Viewer)

[TallMan]

Hey Guys,

It has been a while. Hope all are well.

I am working on trying to get a date field on my subform to turn red when the date that the field list is > 30 days.

In the expression section of conditional formatting I have tried:

DateDiff("d",Date(),"Dt_Approved")>"30"

Any thoughts?

Thank you,

Tallman

 

[vbaInet]

Is the Default View in Single Form, Continuous Form or Datasheet?~

 

[TallMan]

Hello,

It is showing Datasheet view.

Thank you,

 

[vbaInet]

Alright you can use Conditional Formatting. Something like

Field Value Is
Greater Than
Date() + 29

 

[TallMan]

Perfect! Thank you!

 

[vbaInet]

You're welcome!