Date as Measure in Table

[Anonymous]

I am trying to add a field to a table which shows the earliest estimated delivery date of a product. The field comes through fine as a dimension in a table, but when I try to add it as a measure (using MIN([Estimated Delivery]) ) then I just get blank values.

Any ideas why this might be happening and what the solution is?

[sunny_talwar · Accepted solution]

It is actually not coming in as date. See how it is left oriented, if it was truly a date field, it would have been right oriented. Try this in the script:

LOAD Date#([Estimated Delivery], 'DD-MMM-YY') as [Estimated Delivery]

FROM Source

UPDATE: Look at the following links

Why don’t my dates work?

Get the Dates Right

[swuehl]

See also

Why don’t my dates work?

Get the Dates Right

[Anonymous]

Excellent, thanks!