Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Current format of our Date when is DD/MM/YYYY they want the date format to be YYYYMMDD,
I try to do it in Nprinting by changing the format date format but it's not working still the date stays in DD/MM/YYYY,
then i try to change the date format on my computer might be affecting it but same result
thanks this problem is solve
i use this expression
DATE(FLOOR(Timestamp#(YourTimeStampField)),'DD/MM/YYYY')
DATE(FLOOR(Timestamp#(DATE_TRANSACTION)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(DATE_REQUESTED)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(CANCEL_DATE)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(DATE_INVOICE)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(ACTUAL_DELIVERY_DATE)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(GL_DATE)),'YYYY/MM/DD')
Great to hear, please close this thread if complete for Qlik Community Hygiene
@Eduard23 please provide whether you are using QV or Qlik Sense to feed Nprinting (and the versions you are using). In addition, if you can load just that field into an app/document and submit that here it would help in diagnosing the field type/cascade to NPrinting issues.
Ideally you want to feed a clean date from the Qlik Sense/View side, but the typing could impact the way NPrinting is picking it up and what changes need to be made
thanks this problem is solve
i use this expression
DATE(FLOOR(Timestamp#(YourTimeStampField)),'DD/MM/YYYY')
DATE(FLOOR(Timestamp#(DATE_TRANSACTION)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(DATE_REQUESTED)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(CANCEL_DATE)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(DATE_INVOICE)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(ACTUAL_DELIVERY_DATE)),'YYYY/MM/DD')
DATE(FLOOR(Timestamp#(GL_DATE)),'YYYY/MM/DD')
Great to hear, please close this thread if complete for Qlik Community Hygiene