Re: Date in Number Format

Can you elaborate more on what you wanting to achieve? If you already have the key on excel, what are you wanting to change?

Excel date-time is calculated based on the number of days since January 1, 1900. 
Quick Base date-time is calculated in milliseconds since January 1, 1970.

You can convert it in a formula, but you can't set that formula numeric as a key field. So that's why I ask what you are wanting to change in your process.

//from January 1, 1900 to January 1, 1970 = 25,569 days
var number codeone = ToDays([Date1]-Date(1970, 1, 1)+Days(25569));
var number codetwo = ToDays([Date2]-Date(1970, 1, 1)+Days(25569));
var number codethree = ToDays([Date3]-Date(1970, 1, 1)+Days(25569));

$codeone & $codetwo & $codethree​