cf date functions

[coder1957**]

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?

[Charlie Arehart · Accepted solution]

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

And:

https://forums.adobe.com/community/coldfusion

[coder1957**]

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

Was about to delete it when I saw your reply.

[coder1957**]

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?

[Charlie Arehart]

You can file supposed bugs at tracker.adobe.com. Offer clear examples to demonstrate to them.

[coder1957**]

I must have not phrased my question properly.

I thought I read somewhere that there is a DOCUMENTED bug using the "1/1/1900 feature" and I read about it within the past year but now Googling it I can't find it anywhere.

Ring a bell?

[Charlie Arehart]

No, but it is having to infer the date. In some locals, 2/4 would be in Feb, while others would be March. Best to use more explicit date values, or functions that create a date, to be explicit. 

null