next_day

Description

Given a date column, returns the first date which is later than the value of the date column that is on the specified day of the week.

Usage

## S4 method for signature 'Column,character'
next_day(y, x)

next_day(y, x)

Arguments

Details

For example, next_day('2015-07-27', "Sunday") returns 2015-08-02 because that is the first Sunday after 2015-07-27.

Day of the week parameter is case insensitive, and accepts first three or two characters: "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun".

Note

next_day since 1.5.0

See Also

Other datetime_funcs: add_months, add_months, add_months,Column,numeric-method; date_add, date_add, date_add,Column,numeric-method; date_format, date_format, date_format,Column,character-method; date_sub, date_sub, date_sub,Column,numeric-method; datediff, datediff, datediff,Column-method; dayofmonth, dayofmonth, dayofmonth,Column-method; dayofyear, dayofyear, dayofyear,Column-method; from_unixtime, from_unixtime, from_unixtime,Column-method; from_utc_timestamp, from_utc_timestamp, from_utc_timestamp,Column,character-method; hour, hour, hour,Column-method; last_day, last_day, last_day,Column-method; minute, minute, minute,Column-method; months_between, months_between, months_between,Column-method; month, month, month,Column-method; quarter, quarter, quarter,Column-method; second, second, second,Column-method; to_date, to_date, to_date, to_date,Column,character-method, to_date,Column,missing-method; to_timestamp, to_timestamp, to_timestamp, to_timestamp,Column,character-method, to_timestamp,Column,missing-method; to_utc_timestamp, to_utc_timestamp, to_utc_timestamp,Column,character-method; unix_timestamp, unix_timestamp, unix_timestamp, unix_timestamp, unix_timestamp,Column,character-method, unix_timestamp,Column,missing-method, unix_timestamp,missing,missing-method; weekofyear, weekofyear, weekofyear,Column-method; window, window, window,Column-method; year, year, year,Column-method

Examples

## Not run: 
##D next_day(df$d, 'Sun')
##D next_day(df$d, 'Sunday')
## End(Not run)