DateAdd Function

[dougancil]

I am using the following formula on a database field that is an integer. The database is supplied by data from a 3rd party vendor software. What can I use to just return the date?

dateadd(d,monca lladd.adddate, '12/31/1899')-(moncalladd.add date/1000)/60/1440+1

[Rabbit]

If it's just for display purposes, you can use the convert() function to change it into a varchar() variable and specify the third parameter for the format you want to see it in. If it's for storage purposes, you don't want to do that because then it's no longer a datetime variable.