Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i have month filed and i want to show current month plus 1.
example:
i have month May which is current month and i want to show June .
Please can any one help.
Show this where in a text box object?
Have you looked at the addmonths() function?
addmonths(<your date field>) , 1) will return the next month based on a date field.
If your data is just the month name and not a date then something like this will work
month(addmonths(date#('May', 'MMM'), 1))
month(addmonths(date#(<your month field>, 'MMM'), 1))