IPCC D[now] format help

Unanswered Question
Dec 29th, 2008

Hello all,

I am trying to do a simple if D[now] == D[12/29/08] then do x else do y but it is always doing y. x never matches todays date. what is the format of getting D[now]?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Clifford McGlamry Mon, 12/29/2008 - 12:38

John, per our discussion, dump the value of D[now] into a string variable and use the debugger to catch the output.

The bigger question is why this worked last year, this routine is only used during the holiday period), but doesn't work this year.

Anyone know why the test:

D[now] == D[today's date in mm/dd/yyyy format here]

would work last year, but doesn't work this year? The server is still set to the same regional settings.

Clifford McGlamry Mon, 12/29/2008 - 16:32

Server date is correct. However, it appears that the comparison is converting the short date time provided (i.e. 12/29/2008) to a long equivalent like 12/29/2008 00:00:00. I've seen this before in SQL server. I'm just not clear on why it has started occurring with CRS.


This Discussion