Date format

[niha]

Hello,

Here is my code.

Date([ServiceReceivedDate]) as [Date of First Service],
Year([ServiceReceivedDate]) as FSYear,
Month([ServiceReceivedDate]) as FSMonth,
num(Month([ServiceReceivedDate])) as FSMonthabbr,
Day([ServiceReceivedDate]) as FSDay,
Year([ServiceReceivedDate]) & (Month([ServiceReceivedDate])) as FSYearmonth,

Year([ServiceReceivedDate]) &num (Month([ServiceReceivedDate])) as SYearmonth;

My output is like below:

I want to see SYearmonth like 201601, 201602,201603...so on now it is like 20161, 20162.....like on.

Please advice 

Regards,

Niha

[albertovarela]

Add the num format to this line:

Year([ServiceReceivedDate]) &num (Month([ServiceReceivedDate]),'00') as SYearmonth

[rogerpegler]

Or another way:

Date([ServiceReceivedDate],'YYYYMM') as [Date of First Service],