date format as YYYYMM

[vidar.freyr]

I have a default value in a report as YYYYMM.

I run this report on the first day of each month.

Delfault value need´s be last month with this format YYYYMM

In the past I have used
=DateAdd(DateInterval.Month,DateDiff(DateInterval.Month,CDate("01/01/1900"),Now())-1,CDate("01/01/1900"))

But for this report I can't use this it needs to be YYYYMM

 

[IanWaterman]

Not used Cdate before and is not recognised by my copy of MSSQL 2016
You could try changing your CDate section to

CDate('01/'+substring(datefield, 4,2)+'/'+substring(datefield, 1,4)

replace datefield with your field holding YYYYMM, I have assumed this is a string field, if a number then you will need to cast as string first.

Ian