Month from Date YYYY-MM-DD

sush26283 · Post by **sush26283** » Fri Feb 25, 2011 9:45 am

Hi,
I have a querry, a small one...I hope someone can help me out with it.

I need to extract just the month from the date which is in format YYYY-MM-DD. can some one help me out with it.

Thanks in advance

chulett · Post by **chulett** » Fri Feb 25, 2011 9:57 am

This date... is it an actual Date datatype or is it a string? For the former, there are functions to get that, for the latter you can use substring.

Also, you marked the job as Server yet posted in the PX forum, which job type is it? That will change the answer as to the function needed.

sush26283 · Post by **sush26283** » Fri Feb 25, 2011 10:43 am

chulett wrote:This date... is it an actual Date datatype or is it a string? For the former, there are functions to get that, for the latter you can use substring.

Also, you marked the job as Server yet posted in the PX forum, which job type is it? That will change the answer as to the function needed.

its in datetime format, its a server job..

chulett · Post by **chulett** » Fri Feb 25, 2011 11:06 am

OK, so here we are in the correct forum now. You should be able to use OConv for this, just the "MM" mask should get you what you want.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 25, 2011 2:00 pm

If you're reading a string containing a timestamp, just use substring technique.

Code: Select all

InLink.TheString[6,2]

If you want to remove leading zero, just use this in an arithmetic expression.

Code: Select all

InLink.TheString[6,2] + 0

Since server edition does not have an internal timestamp representation that's all the discussion there needs to be.

Oconv() is not your friend here.