change date to first day of next month

[jaiiracha]

Hello - If i have a date that reflects the last day of the month for e.g 4/30/23 or 5/31/23. How can i modify this to reflect the first day of the next month so 4/30/23 would now be 5/1/23 and 5/31/23 would now be 6/1/23. BUT if we have dates that fall in mid-month for e.g. 4/21/23 or 5/15/23, these should remain the same. THANK YOU!!!

[jbravman_ · Accepted solution]

if todate(datetimetrim([DateField],'lastofmonth'))= [DateField] then  todate(datetimeadd(datetimetrim([DateField],'lastofmonth'),1,'days')) else todate(DateField) endif 

e: spelling. 

[binuacs]

@jaiiracha I assume all of your dates will be the last of the month

[Rana_Kareem]

Hi @jaiiracha ..

You can use these expressions :