I want to create a new field in Load clause which is named [Last day]. And this is calculated by the two existed field in the same load clause [submit date] & [Last modified date].
I think i find another problem, can qlikview make minus operation just on the date? If below two types date is captured with left() function i think the minus operation cannot be done. So how can i calculate the duration between submit and last modified?
the Last modified date and Submit date is combined with Date and time. SO I use Left first to capture the date. and then use Date# to change the char type to date type. then I use Interval to make the minus.
BUT the system tells me that the field(<Submit>) cannot be found... could you please help me again?