|
#1
|
|||
|
|||
|
Confusion with xpath date comparisons?
I’m getting confused with xpath date comparisons, I want to return all values where a @Publication_x0020_Date occurs this month, the below comparison returns all publications only on today’s date rather than this month. I need the date to remain dynamic as I would prefer this to automatically update on a monthly basis.
Code:
[number(translate(substring-before(@Publication_x0020_Date,'T'),'-','')) = number(translate(substring-before($Today,'T'),'-',''))] Any help appreciated. |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help in Xpath query for comparing a date with todays date | rachael | XML | 1 | 01-27-2009 09:52 AM |
| JAVA Date Utility Tutorial | hemanthjava | Java | 0 | 07-05-2006 11:08 PM |
| date comparisons in SQL | Blair | VB Classic | 19 | 11-13-2000 03:12 PM |
| Date Comparisons in SQL | Vicky Diamond | VB Classic | 0 | 10-22-2000 05:06 AM |
| SQL Date comparisons in VB | Blair | VB Classic | 1 | 10-17-2000 05:47 PM |