Forum Discussion
Dnike232
4 years agoNew Member
MYSQL data import
Hey, looking to format data from MySQL. Colume comes in as a 10dig number and I need to run this formula against it =A1/86400+DATE(1970,1,1) ** This is an excel forumal** (In excel) After the convers...
HotChilli
4 years agoCommunity Champion
I get what you're trying to do. I'm asking what's happening when you try it in Power Query (once you've connected to your MySql data source) and used Add Custom Column with your formula.