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: 
dudumoscona
Contributor
Contributor

dates shown correct in one machine and in another machine displayed wrong

Hi all,

i have a module that in one PC the date field show correctly and in another PC/Machine show wrong .

 

Attached 2 of the results - how could it be ?

 

wrongwrongcorrectcorrect

1 Solution

Accepted Solutions
jerifortune
Creator III
Creator III

I have formatted the date for you.

What I did:

Properties >> Number >> Override document Settings >> Date.

Hope this works for you.

View solution in original post

6 Replies
jerifortune
Creator III
Creator III

Try formatting the date field using date function. Eg. Date(Finalized, 'm/d/yyyy')

I can see both systems are producing wrong date. You cannot have 56/10/2018 as date. Something might be wrong with the dataset.

dudumoscona
Contributor
Contributor
Author

still not working, the first one does show correct btw  - you can see only valid dates there.

tharanikannan
Contributor III
Contributor III

Hi ,

Please attach a sample data. 

dudumoscona
Contributor
Contributor
Author

issue is on finilized field,

WOCMMS:

LOAD
WOPK as [key],
WOID ,
StockRoomPK,
StockRoomID,
StockRoomName,
RepairCenterPK,
RepairCenterID,
RepairCenterName,
SupervisorPK,
SupervisorID,
SupervisorName,
ProjectPK,
ProjectID,
ProjectName,
ShopPK,
ShopID,
ShopName,
DepartmentPK,
DepartmentID,
DepartmentName,
TenantPK,
TenantID,
TenantName,
WarrantyBox,
ShutdownBox,
LockoutTagoutBox,
AttachmentsBox,
SurveyBox,
Survey_ID,
PrintedBox,
Instructions,
LaborReport,
Chargeable,
FollowupWork,
ProblemPK,
ProblemID,
ProblemName,
FailurePK,
FailureID,
FailureName,
SolutionPK,
SolutionID,
SolutionName,
Component,
ComponentDesc,
FaultLocation,
FaultLocationDesc,
FailedWO,
AuthStatusUserPK,
AuthStatusUserInitials,
AuthStatusDate,
Requested,
Issued,
OnHold,
CompletePercent,
Complete,
Closed,
Canceled,
Denied,
CostLaborActual,
CostEmployeeActual,
CostContractorActual,
CostPartActual,
CostMiscActual,
CostTotalActual,
CostLaborEstimated,
CostEmployeeEstimated,
CostContractorEstimated,
CostPartEstimated,
CostMiscEstimated,
CostTotalEstimated,
ChargeLaborActual,
ChargeEmployeeActual,
ChargeContractorActual,
ChargePartActual,
ChargeMiscActual,
ChargeTotalActual,
ChargeLaborEstimated,
ChargeEmployeeEstimated,
ChargeContractorEstimated,
ChargePartEstimated,
IsOpen,
IsApproved,
Finalized,
year(Finalized),
Month(Finalized),
Currency


FROM
[..\1_Raw\WO.QVD]
(qvd);

LEFT JOIN

WOPart:

LOAD
PK,
RecordType,
WOPK as [key],
PartPK,
PartID ,
PartName,
LocationPK,
LocationID,
LocationName,
DirectIssue,
OutOfPocket,
POPK,
PODetailPK,
QuantityActual,
CategoryPK,
CategoryID,
CategoryName,
SerialReplacedOutOfService,
PartDate,
Bin,
LaborToPK

FROM
[..\1_Raw\WOPart.QVD]
(qvd);



STORE WOCMMS INTO [..\..\1_resources\1_Raw\WOCMMS.QVD];
DROP Tables WOCMMS;








dudumoscona
Contributor
Contributor
Author

i've attached sample data

jerifortune
Creator III
Creator III

I have formatted the date for you.

What I did:

Properties >> Number >> Override document Settings >> Date.

Hope this works for you.