https://community.qlik.com/t5/Talend-Studio/TalendDate-setDate-impossible-to-set-minutes/m-p/2372404#M135246 Hi everybody, <BR />I try to use the TalendDate.setDate function. It works fine with the following statement: <BR />tmpDate = TalendDate.setDate(context.CurEndDate, 0, "HH"); <BR />It sets the hour to 00 <BR />but when I want to set the minutes to 00: <BR />tmpDate = TalendDate.setDate(context.CurEndDate, 0, "mm"); <BR />it says : <BR />java.lang.RuntimeException: Can't support the dateType: mm <BR />Why can't we set minutes using this function ? <BR />And how can I work this around to set my date to midnight (for instance: 2012-04-03 12:00 becomes 2012-04-03 00:00) <BR />thanks in advance! Tue, 03 Apr 2012 10:36:55 GMT Anonymous 2012-04-03T10:36:55Z https://community.qlik.com/t5/Talend-Studio/TalendDate-setDate-impossible-to-set-minutes/m-p/2372404#M135246 Hi everybody, <BR />I try to use the TalendDate.setDate function. It works fine with the following statement: <BR />tmpDate = TalendDate.setDate(context.CurEndDate, 0, "HH"); <BR />It sets the hour to 00 <BR />but when I want to set the minutes to 00: <BR />tmpDate = TalendDate.setDate(context.CurEndDate, 0, "mm"); <BR />it says : <BR />java.lang.RuntimeException: Can't support the dateType: mm <BR />Why can't we set minutes using this function ? <BR />And how can I work this around to set my date to midnight (for instance: 2012-04-03 12:00 becomes 2012-04-03 00:00) <BR />thanks in advance! Tue, 03 Apr 2012 10:36:55 GMT https://community.qlik.com/t5/Talend-Studio/TalendDate-setDate-impossible-to-set-minutes/m-p/2372404#M135246 Anonymous 2012-04-03T10:36:55Z https://community.qlik.com/t5/Talend-Studio/TalendDate-setDate-impossible-to-set-minutes/m-p/2372405#M135247 well, an idea (not the best one for sure): <BR />Date tmpDate; <BR />String stmpDate; <BR />tmpDate=context.CurEndDate; <BR />// convert to string with yyyy-MM-dd format <BR />stmpDate = TalendDate.formatDate("yyyy-MM-dd", tmpDate); <BR />// concat with time to midnight <BR />stmpDate = stmpDate + " 00:00"; <BR />// parse to Date with format yyyy-MM-dd HH:mm <BR />tmpDate=TalendDate.parseDate("yyyy-MM-dd HH:mm", stmpDate); <BR />it returns the date set to midnight Tue, 03 Apr 2012 10:54:40 GMT https://community.qlik.com/t5/Talend-Studio/TalendDate-setDate-impossible-to-set-minutes/m-p/2372405#M135247 Anonymous 2012-04-03T10:54:40Z