how to get end date of the month

[RAJEEV KATTA]

I have a scenario where in I need to take DSJobStartDate and find the end date of the previous month.I know how to get the end of the month but how do I go back to the previous month from DSJobStartDate.

[neena]

Try this i got the logic from another post and modified the stage variables logic, but i am not sure.

Declare 3 stage variables like below.

SvRUN_DT = DSJobStartDate

svYear= YearFromDate(SvRUN_DT)

svMonth= MonthFromDate(SvRUN_DT)

Then in the output derivation for RUN_DT, put:

If MonthFromDate(RUN_DT) = 10 or MonthFromDate(RUN_DT) = 11 or MonthFromDate(RUN_DT) = 12 then
DateFromDaysSince(-1, StringToDate(svYear : "-" : svMonth : "-01") ) else DateFromDaysSince(-1, StringToDate(svYear : "-" : "0" : svMonth : "-01") )

[ArndW]

I would use the following logic:

1. Convert the DSJobStartDate to a string in the format YYYY-MM-DD
2. Replace the last two characters in the string with 01
3. Convert the String back to a Date
4. Subtract 1 day from the Date

[neena]

Try this logic, its somewhat similar to Arndw i guess.

Create one stage variable.

SvRUN_DT(Varchar) = DSJobStartDate[1,8]:01

Then in the output derivation for RUN_DT, put:

DateFromDaysSince(-1, StringToDate(SvRUN_DT) )

[bcarlson]

If DSJobStartDate = 2008-10-15, then subtract the number days. In this case, 15.

In DB2 SQL, this would be as follows:

Code: Select all

select current date - day(current date) days .....

or

Code: Select all

2008-10-15 - 15 days = 2008-09-30

Seems like this should always give you the last day of the prior month, shouldn't it? I haven't done much date arithmetic in DS, we typically are pulling from a database and do it in SQL. Does DS have an easy way to subtract N number of days from a date and have a valid date?

Brad

[ray.wurlod]

You could use DayFromDate() to get the day number and DateFromDaysSince() to get the new date.