How to check if we are at the first day of the current month.

[ezybusy]

Hi guys
I would like to know how i can do the followings:
> How i can check if we are at the first day of the current month?
> And how to check if the that first day is not Sunday.



I came across the following:

DateSerial(year(Date), month(Date), 1)

but it doesn't do the job.

Thanks

[CJ_London]

use day(date())

and for day of week use the weekday function

weekday(date())

Sunday=1

[orange]

To determine if the first day of the current month is a Sunday
?iif(weekdayName(day(DateSerial(year(date), Month(Date), 1))) = "Sunday","yes Sunday","not Sunday")
yes Sunday

[ezybusy]

Perfect. Works like a charm. Thx a lot