Highlighted

Date formula for 1st of the month following an existing date field

New Here ,
Mar 22, 2019

Copy link to clipboard

Copied

I would like to create a calculated field where the date returned is the first of the month following the date of hire, which is a field filled out by the employee. Doing date([date of hire])+30 doesn't work because it'll add 30 days to the date rather than returning the 1st of the next month. Any ideas?

Topics

Questions Need Help

Views

74

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Date formula for 1st of the month following an existing date field

New Here ,
Mar 22, 2019

Copy link to clipboard

Copied

I would like to create a calculated field where the date returned is the first of the month following the date of hire, which is a field filled out by the employee. Doing date([date of hire])+30 doesn't work because it'll add 30 days to the date rather than returning the 1st of the next month. Any ideas?

Topics

Questions Need Help

Views

75

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Have something to add?

Join the conversation