Skip to Content
avatar image
Former Member

WebI: Get the date 01/01/[next year]

Hi,

How do I get in WebI the first day in January of the next year? At least I want to insert an Input control where the default value is the 01/01/next year to filter values in a table.

Thanks for your support

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 08, 2017 at 06:01 PM

    use this.this will give you the date value 01/01/2018

    =ToDate("01/01/"+FormatNumber(Year(CurrentDate())+1;"##");"dd/MM/yyyy")

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 08, 2017 at 05:27 PM

    Hi,

    Try this formula

    =RelativeDate(RelativeDate(CurrentDate();-DayNumberOfYear(CurrentDate()));1)

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded