MONTH & YEAR FROM DATE

ajithaselvan · Post by **ajithaselvan** » Thu Jan 06, 2011 4:35 am

Hi,
Pls let me know what is function to be used to get
only month & year from date. Format is below

Input: YYYY-MM-DD
Output: MM-YY

Thanks & Regards,

dr.murthy · Post by **dr.murthy** » Thu Jan 06, 2011 4:53 am

Use substring function

ajithaselvan · Post by **ajithaselvan** » Thu Jan 06, 2011 4:59 am

Thanks Murthy

chulett · Post by **chulett** » Thu Jan 06, 2011 6:23 am

This 'date' field, what actual data type are we talking about? The current answer is fine if you are talking about a string but it's not correct for an actual 'date date'.

ajithaselvan · Post by **ajithaselvan** » Thu Jan 06, 2011 6:53 am

Hi chulett,
What would be the correct ans if the data type is date?

Thanks & Regards,

Ravi.K · Post by **Ravi.K** » Thu Jan 06, 2011 8:09 am

you have to use "DateToString" function to define correct date mask.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 06, 2011 3:38 pm

Code: Select all

Right("00":MonthFromDate(InLink.TheDate) : "-" : Right(YearFromDate(InLink.TheDate),2)

dsa · Post by **dsa** » Thu Jan 06, 2011 11:33 pm

ray.wurlod wrote:

Code: Select all

Right("00":MonthFromDate(InLink.TheDate) : "-" : Right(YearFromDate(InLink.TheDate),2)

...

Ray,

Should we use:

Right("00":MonthFromDate(InLink.TheDate),2) : "-" : Right(YearFromDate(InLink.TheDate),2)

??? as the requirement is MM-YY?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 07, 2011 12:33 am

Can you please advise what you think is wrong with the expression I gave?

Have you tried it?

chulett · Post by **chulett** » Fri Jan 07, 2011 8:04 am

Took me a minute but the difference is the "2" that was added at the end of this part for the month:

Code: Select all

Right("00":MonthFromDate(InLink.TheDate),2)

ray.wurlod · Post by **ray.wurlod** » Fri Jan 07, 2011 4:27 pm

Code: Select all

Right("00":MonthFromDate(InLink.TheDate), 2) : "-" : Right(YearFromDate(InLink.TheDate), 2)