NextWeekdayFromDate() Function in Transformer Stage in DataStage

NextWeekdayFromDate function returns the date of the specified day of week soonest after the source date. The day of the week is specified as the full name, for example, thursday, or a three-letter abbreviation, for example, thu.
Input: sourcedate (date), day_of_week (string)
Output: date
Examples. If mylink.mysourcedate contains the date 2008-08-18, then the two following functions are equivalent, and return the value 2008–08–21:
NextWeekdayFromDate(“2008-08-18”, “thursday”)
NextWeekdayFromDate(mylink.mysourcedate, “thu”)

You can watch video tutorial of this function here:



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: