Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
param123
Creator
Creator

TalendDate.diffDateFloor

Hi All,

 

I am giving the correct datatype as per the talend documentation, but somehow I am getting an error or the below:

 

int B=TalendDate.diffDateFloor(TalendDate.parseDate("dd-MM-yyyy HH:mm:ss","2006-01-01 08:20:20"),TalendDate.parseDate("dd-MM-yyyy HH:mm:ss","2006-01-01 08:00:20"),"mm") ;

 

 

the error is:

Can't support the dateType: mm ,please try "yyyy" or "MM".

 

it is taking only yyyy or MM..any idea what datatype to be given for minutes and seconds and hours?

 

 

 

Labels (1)
1 Solution

Accepted Solutions
param123
Creator
Creator
Author

Strange, it is working with "ss", "mm" for diffDate function, but not diffDateFloor ...completely different from what is mentioned in documentation.

 

anyways...I am marking this as solved.

 

But if anyone has anything to comment on the above, Please feel free to do so. I would like to know what is the gap here.

 

View solution in original post

1 Reply
param123
Creator
Creator
Author

Strange, it is working with "ss", "mm" for diffDate function, but not diffDateFloor ...completely different from what is mentioned in documentation.

 

anyways...I am marking this as solved.

 

But if anyone has anything to comment on the above, Please feel free to do so. I would like to know what is the gap here.