cf date functions

This is not an advanced issue ... but I cannot find in this forums software where to ask general questions about CF.

Navigation could be far better!

Ok ... I have an integer ... 43629 ... the day of a given date since 1/1/1900.

How do I do the reverse?

I need to make a date from that integer?

Anyone?

This topic has been closed for replies.

Correct answer Charlie Arehart

dateadd('d',43629,'01-01-1900')

And:

Correct answer

Community Expert

dateadd('d',43629,'01-01-1900')

And:

/Charlie (troubleshooter, carehart. org)

Known Participant

As soon as I posted that, I had one of those DOH moments.

Was about to delete it when I saw your reply.

Known Participant

However, is there not a "bug" in CF where the integer we get from datdiff from 1/1/1900 is actually like 1-2 days off?

As CF returns the value of something like December 31 1989?

Cause I've also noticed when I try to highlight "today" in my calendar it is off by a day one day, the 2 days off on others?

Sign up