Tag Info

Hot answers tagged

1

You need two calculated columns and apply filter Start of the Month =DATE(YEAR(DateField),MONTH( DateField),1) End of the Month =DATE(YEAR( DateField ),MONTH( DateField)+1,1)-1 Filter "Start of the Month" is Less than or Equle to [Today] Or "End of the Month" is Greater than or Equal to [Today]


1

A formula like this should do the trick. =CONCATENATE(MONTH(DATE_FIELD_NAME),"/1/",YEAR(DATE_FIELD_NAME))


1

Try this formula: =CONCATENATE(MONTH([Date]),"/1/",YEAR([Date]))



Only top voted, non community-wiki answers of a minimum length are eligible