topic Convert dates fron SQL to normal date format in Developer

Convert dates fron SQL to normal date format

gidon — Fri, 14 Oct 2016 12:45:54 GMT

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 — Fri, 14 Oct 2016 14:27:54 GMT

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

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

gidon — Fri, 14 Oct 2016 15:43:14 GMT

thank you very much

gidon

Greg_Deckler — Fri, 14 Oct 2016 15:45:16 GMT

Happy to help!