• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

cf date functions

Community Beginner ,
Jun 08, 2019 Jun 08, 2019

Copy link to clipboard

Copied

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?

TOPICS
Advanced techniques

Views

583

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jun 08, 2019 Jun 08, 2019

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

And:

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

Votes

Translate

Translate
Community Expert ,
Jun 08, 2019 Jun 08, 2019

Copy link to clipboard

Copied

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

And:

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


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 08, 2019 Jun 08, 2019

Copy link to clipboard

Copied

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

Was about to delete it when I saw your reply.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 09, 2019 Jun 09, 2019

Copy link to clipboard

Copied

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?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 09, 2019 Jun 09, 2019

Copy link to clipboard

Copied

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


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 09, 2019 Jun 09, 2019

Copy link to clipboard

Copied

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?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 09, 2019 Jun 09, 2019

Copy link to clipboard

Copied

LATEST

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


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation