Minus 62 days from Current_Date but need 1st day of the mont

[imfarhan]

I'm using following code to get minus -62days of the current date :

Code: Select all

Ereplace(Oconv(iconv(DSJobStartDate,"D-YMD")-62,"D-YMD[4,2,2]"),"-","")

The output I'm getting is
pPeriodStartDate= 20131115

20131115 -62days

Now I need '01' instead of '15' , meaning 1st day of the month so it should be like 20131101 instead of 20131115 or
Replace the 'dd' value to constant value '01'

Many thanks in advance

Kind regards
Farhan

[priyadarshikunal]

may be just take a substring and add the constant value

Code: Select all

Ereplace(Oconv(iconv(DSJobStartDate,"D-YMD")-62,"D-YMD[4,2,2]"),"-","")[1,6]:"01"

[imfarhan]

Thanks a lot Priyadarshikuna
Its work perfectly fine.

Kind regards
Farhan

[ray.wurlod]

A bit overly complex but, as you say, it works. I'd use Iconv(), arithmetic, then the MONTH.FIRST transform.