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

[dudumoscona]

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

[jerifortune]

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]

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

[tharanikannan]

Hi ,

Please attach a sample data. 

[dudumoscona]

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]

i've attached sample data

[jerifortune · Accepted solution]

I have formatted the date for you.

What I did:

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

Hope this works for you.