Convert dates fron SQL to normal date format

[gidon]

Hi Guy

I start to make my first doc ,  I get field from my data base  as date

it look like this

9357120
9524160
9943200
10218240
10530720
10581120
10782720
10794240
10920960
10955520

it is date or date and time

with qlik i had a script like this

date(makedate(1988,1,1)+(IVDATE/(60*24))) AS  DOCDATE

how do i convert in power BI

thanks

gidon

[Greg_Deckler · Accepted solution]

Well, I *believe* the equivalent formula in Power BI would be:

DOCDATE = DATE(1988,1,1) + [IVDATE]/(60*24) * 1.

[gidon]

thank you very much

gidon

[Greg_Deckler]

Happy to help!