Reply To: extract month and year from a datefield in database

Forums Designer Building applications extract month and year from a datefield in database Reply To: extract month and year from a datefield in database

    Eddie Heijblom
    Moderator
    Up
    0
    Down

    We have a workaround for that.

    Create a data-item with all dates from today till 5 years from now in the first colum, in the second the month number or name and in the third the year.

    Import this Excel into your application.

    Create a reference for this date which you would like to report on. When you save a date also link this date to this data-item in a flowpart. Do this by creating a lookup where the value of the user is equal to the date in the data-item.  Save the reference to this date at this record.

     

    Tip: In Excel always note dates like yyyy-mm-dd to prevent American/European date format issues. 9/11 is September 11th in the US, while in the EU it’s November 9th

Get started for free and experience the power of the Triggre platform.

By signing up for your free account, you agree to receive e-mails from Triggre.