Change binary to date from SQL DB

[KBO]

Hi,

I would like to change the binary code from my timestamp column to a date. I try Text.FromBinary but than I get a question mark symbol. Can anybody help?

[KBO · Accepted solution]

Solved the problem - not complete but for my needs it is ok.

Used = Binary.ToList([timestamp])

And than extract values.

So I have a counter, not time or date based  but it works :). If somebody had a solution with date and time I will try it :).

[artemus]

Looking at the binary value, it appears to just be the year number, since 0x7D1 is 2001

[Jimmy801]

Hello

I don't think that this time-stamp-value can be converted to a date, because it  does represent some kind of counter.

BR

Jimmy

[KBO]

So that is the problem, actually it is a counter. If I go to my PowerApp and add a value the column value changed at the end. If I change a data set in the power app the timestamp also changed and counted up. So I think it referes to the last action in the DB but how can I extract it into Power BI ...