Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I have a table containing the order date in three separate fields: date, month and year.
I have tried to use :
In english the error message is: Can not convert the value 10.1.2019 for type Text to type Date.
I guess I have to add a leading zero before the "1" in the example. Any ideas?
Best regards
Kenneth Pedersen
Solved! Go to Solution.
Could you use the DATE function? Something like
ORDREDATO = DATE( ORDR[ORD_AAAA], ORDR[ORD_MM], ORDR[ORD_DD] )
@Anonymous
ORDERDATO = DATE(YEAR(ORDR[ORD_AAAA]),MONTH(ORDR[ORD_MM]),DAY(ORDR[ORD_DD]))
@Anonymous
ORDERDATO = DATE(YEAR(ORDR[ORD_AAAA]),MONTH(ORDR[ORD_MM]),DAY(ORDR[ORD_DD]))
Could you use the DATE function? Something like
ORDREDATO = DATE( ORDR[ORD_AAAA], ORDR[ORD_MM], ORDR[ORD_DD] )
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |