Last day of month

T

TUNSTAD

Please can anyone help.

I want to be able to set a column as 1 if a start date is the last day of
the month.

Example: someones start date is on the 31/01/2006 I want it to be something
like:

IIf ([Start_Date]="Last day of month",1,0) but I don't know how to calculate
if it is the last day of the month?

Many thanks in adavance
 
O

Ofer

Try this

IIf ([Start_Date]=#" & DateSerial(Year([Start_Date]), Month([Start_Date]) +
1, 0) & "#,1,0)
 
Top