In FreeMarker Template Language (FTL) script, the date format is set as ‘October 1, 2023 – October 31, 2023’, So the client needs to change this date format to ‘01.10.2023 – 31.10.2023’ (DD.MM.YYYY). _startdate: [“2023″,”10″,”01”],_enddate: [“2023″,”10″,”31”], The code for the date format ‘October 1, 2023 – October 31, 2023‘ is given below 2. The code… Continue reading Date format in FreeMarker Template Language (FTL)
Tag: date format
Setting the Date Created to a specified Date format
By using a transaction saved search we can set the Date Created to a specified Date format. For example, if the Date format of an account is MM/DD/YYYY and of another account is DD/MM/YYYY. In both these cases we can set to a specified format of Date as we required. Under the Result tab give… Continue reading Setting the Date Created to a specified Date format
Generate date object with the given date
/** * To generate Date Object with the given data * @param {[Number,Number,Number]} dataArray * @returns {Date} */ function generateDate(dataArray) { if (dateLogic.checkDateFormat(dataArray)) return new Date(Number(dataArray[0]), Math.abs(Number(dataArray[1]) – 1) % 12, dataArray[2]); return new Date(‘false’); } /** * @description To check whether the given date is in format of [Number,Number,Number]. ie, [YYYY,MM,DD] * @param {dateArray}… Continue reading Generate date object with the given date
Concatenate the Date field in Excel
When the date field is concatenated with any text field in excel, in the result field the date formate may change. The date value may also be converted to some other format. To avoid this convert the date field to the text field while concatenating. Ex: COCATENATE(TEXT(C2,”dd/mm/yyyy”),E2) In this formula, the date value in C2… Continue reading Concatenate the Date field in Excel