Date order from lookup is not working

1

49

If I want to sort a lookup date, it’s not recognized as date. Any suggestions?

2

It looks like a date but it’s actually a row reference - you’re just seeing a date because that’s the display field. The solution is to add a date column to your table with a formula that pulls it from the lookup table. Then, order by the new column and hide it. That should fix it.

2 Likes
3

Tested and confirmed for myself @Nick_Milner 's solution:

1 Like
4

Thanks @Nick_Milner for your help. Thought I can make it w/o adding a new column.

1 Like