About ate issue

[xihan]

Dear all:

how to return the end date of the month of the given arbitrary date in my transformation??

anyone can help for that?
thx for helping me!

Regards,
Jeff

[SignorRossi]

Hi,
I think something like this should work in a JavaScript step:

var firstOfThisMonth = str2date("01." + num2str(month(givenDate),"00") + "." + num2str(year(givenDate),"0000") ,"dd.MM.yyyy")
var firstOfNextMonth = dateAdd(firstOfThisMonth, "m", 1);
var lastOfThisMonth  = dateAdd(firstOfNextMonth, "d", -1);