Finding First of the Month

[MTSPEER]

Hello,



I have a field(Field1) set up in the date format yyyymmdd. I am trying to find the first of next month for whatever date is in that field. For example 20170403 to 20170501. Thank you!

[jwhite]

I can only assume "Field1" is a text data type. If so: dateserial(left("20170403",4),mid("20170403",5,2)+ 1,1). Does it have to be returned in the same format? If so, then: format(dateserial(left("20170403",4),mid("20170403 ",5,2)+1,1),"yyyymmdd")

Replace the literal string date with your variable/field name.

[MTSPEER]

Thank you very much!