converting date field DD TO MM

[ravikumar_iyana]

Hi,

I want to convert MONTH field -> DATE field

1. Based on date field DD/MM/YYYY(presentDATA)-> YYMM (requiredDATA).
2. after completing converstion not required to repet .

* NOTE: Converting DD into MM

DD/MM/YYYY(PRESENTDATA)	YYMM(REQUIREDDATA)
01/01/2016	1601
02/01/2016	1602
03/01/2016	1603
01/02/2016
02/02/2016
03/02/2016

I'm tried like this

DATE(DATEFIELD,'DD/MM/YYYY') INTO DATE(DATEFIELD,'YYMM')

its not working.

Thanks,

Ravi

[pradosh_thakur]

MID(date(DATE#(DATEFIELD,'DD/MM/YYYY'),'YYYYMM'),2)  AS datefield_new

or

if already on date format

MID(date(DATEFIELD,'YYMM') ,2) AS datefield_new

[krishna_2644]

Try this : right(year(Date),2) & date(date#( Date ,'MM/DD/YYYY'),'MM') as YYMM;

t:

load *,right(year(Date),2) & date(date#( Date ,'MM/DD/YYYY'),'MM') as YY;

load * inline [

Date

01/01/2016

02/01/2016

03/01/2016

01/02/2016

02/02/2016

03/02/2016

];

[ravikumar_iyana]

Hi Krishna,

my requirement is in FIELD: YY dont want to repate

ex:

yy:

1601

1602

1603

[krishna_2644]

on the front end? what chart you want?

you have non distinct dates in the dates hence you are seeing the YYMM multiple time for every value of Date.

[OmarBenSalem · Accepted solution]

table:

load Distinct date(convertedDate,'YYMM') as DateFinal;

load Distinct date(Date#(DateField,'MM/DD/YYYY'),'DD/MM/YYYY') as convertedDate;

load date(Date#(MyDate,'DD/MM/YYYY')) as DateField inline [

MyDate

01/01/2016

02/01/2016

03/01/2016

01/02/2016

02/02/2016

03/02/2016

04/02/2016

];

NoConcatenate

Final:

load DateFinal where peek=0;

load if(previous(text(DateFinal))=text(DateFinal),1,0) as peek, DateFinal;

load   DateFinal Resident table Order by DateFinal;

Drop Table table;

Result: