fbpx

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

    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 a free trial to discover what Triggre has to offer!

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