topic Re: dates shown correct in one machine and in another machine displayed wrong in QlikView

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

dudumoscona — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

wrongcorrect

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

jerifortune — Wed, 14 Nov 2018 18:14:48 GMT

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.

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

dudumoscona — Thu, 15 Nov 2018 08:11:08 GMT

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

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

tharanikannan — Thu, 15 Nov 2018 08:21:28 GMT

Hi ,

Please attach a sample data.

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

dudumoscona — Thu, 15 Nov 2018 08:27:00 GMT

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;

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

dudumoscona — Thu, 15 Nov 2018 08:31:42 GMT

i've attached sample data

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

jerifortune — Thu, 15 Nov 2018 12:34:25 GMT

I have formatted the date for you.

What I did:

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

Hope this works for you.