conditional formatting

[hinser13]

I would like to know the best way to colour a field if a day of the week (Mon-Sund) is not displayed.

Tried the between function Monday to sunday with no success, any ideas?

Thanks mark

 

[Mr. B]

Could you provide just a little more detail of what you are doing now and the condition your are trying to monitor?

 

[hinser13]

I am trying to set conditional formatting to colour a field if it does not display a day name, either: Monday, Tuesday, Wednesady, Thursday, Friday, Saturday or Sunday.

I have tried the not between function Monday to sunday to no avail.

Thanks Mark

 

[gemma-the-husky]

how does the dayname get there - the normal way is just to format the date, as a DAY display - so no day is equivalent to a null date.

I suspect you are doing something different.

 

[hinser13]

I have 31 fields representing 31 days in the month and these are linked to month and year fields. so you get this in each fields: ="07" & " - " & [Month] & " - " & [Year] and then i get the day name by using this for each of the 31 days: =Format([Text253],"dddd").

However not all months have 31 days and where the last 3 day's in each month change (29,30,31) dependant on the month and I want to colour these days to make it obvious that they do noy exist in the relevant month for the booking calendar.

so using formatting on these last three days in each month to say: if not a day name coulour it.

But How? Help much appreciated!

 

[smig]

I kinda lost you here, since first you talked about the day of week (mon-sun) now you talk about the day of month

for day of month this should work:
IsDate(Day & Month & Year) = false

 

[vbaInet]

Use DateSerial() to get the last day of the corresponding month. Compare it against the days in your table.

E.g.

Expression Is [DayInTable] > DateSerial(...)

 

[gemma-the-husky]

unless this info comes from another system, its a strange way of going about it. normally you would just store the date as a single field - then you get numerous date functions to handle the dates

eg format(somedate,"dddd") generates the weekday name

------------------
however, if you assemble your details to form a string

so eg 29/02/2011 then the function isdate will determine whether its a real date or not

isdate("29/2/11") = false
isdate("28/2/11") = true

so you could use this test, in a conditional format statement to manage the display.