I have tried a bunch of things, but am unable to convert the TimeCardDate (DD-MON-YY) from a string to a date field.
Any help would be appreciated - here is the format of the data:
Please try this:
LOAD Date(Date#(lower(TimeCardDate),'DD-MMM-YY')) as TimeCardDate Inline [
worked like a charm - thank you
Retrieving data ...