As stated above, you need to be able to set white balance on the camera manually or take a preset white balance shot that you can store in the camera settings.
Many point and shoots don't offer either function but dslr's do. And even dslrs only go to 10k-14k. Which you know by your light's temp is usually not enough. But it's much closer than your camera's auto wb setting will get you which means it usually only takes some slight tweaking in post to get it fairly spot on to what you see.