Date Format

[niha]

Hello, 

I have a Yearmonth Field and the code is : 

Year(Date(Date#([Date Paid],'YYYY/MM/DD'))) &num( Month(Date(Date#([Date Paid],'YYYY/MM/DD')))) as DPYearmonth,

it comes below format but user want the format like 201701. 201702, 201703 so on. Please suggest

Regards,

Niha

[sunny_talwar · Accepted solution]

Try this

Date(MonthStart(Date#([Date Paid],'YYYY/MM/DD')), 'YYYYMM') as DPYearmonth,

[marcus_sommer · Accepted solution]

You could do it in this way:

Year(Date#([Date Paid],'YYYY/MM/DD')) * 100 + Month(Date#([Date Paid],'YYYY/MM/DD'))

- Marcus

[niha]

Hi,

I wanted to add few more. i have two date format. 

1. I need the Year month to come like 201701, 201702, 201703......201601 so on...

2.  I also need to sort like 201601, 201602, 201603 s.........201701, 201702 in both cases. Please advice

Niha

[niha · Accepted solution]

Thanks all. it worked.