No announcements
Found 2668787 threads
-
0 Votesdate function help
Hello, I'm using the following date functions to set Date variables in a report that I'm building and everything is fine.Answered | 3 Replies | 749 Views | Created by malibu2 - Thursday, July 2, 2015 6:05 PM | Last reply by --CELKO-- - Thursday, July 2, 2015 8:05 PM
-
0 Votes
Help in date function
Please help in this script why format DDMMYY showing wrong in October.Answered | 4 Replies | 3660 Views | Created by Khan_K - Tuesday, September 29, 2009 2:42 AM | Last reply by Melissa Suciadi - Tuesday, September 29, 2009 4:49 AM -
0 Votes
Help with Date Function
Date Completion).Answered | 1 Replies | 6529 Views | Created by SPA-TMF - Tuesday, September 15, 2009 5:24 PM | Last reply by Kolan Veera Reddy - Tuesday, September 15, 2009 6:05 PM -
1 Votes
Date Function help ........
Closedtime = 07:40:12 with the above column values when i add this date function' DATEDIFF(MINUTE,Calllog.RecvdTime,Calllog.ClosedTime) AS ...Answered | 3 Replies | 2176 Views | Created by Farhan1 - Tuesday, November 15, 2011 2:30 AM | Last reply by Deepak Munigela - Tuesday, November 15, 2011 2:57 AM -
3 Votes
date function
Thanks for the help folks, I'll give it a whack!Answered | 9 Replies | 1313 Views | Created by Russ Adams - Tuesday, February 19, 2013 3:58 PM | Last reply by Russ Adams - Thursday, February 28, 2013 3:41 PM -
3 Votes
date function
Hi Neil, Do the answers above help you?Answered | 6 Replies | 1142 Views | Created by Neilcse - Wednesday, January 1, 2020 1:04 AM | Last reply by Lily Lii - Thursday, January 2, 2020 6:13 AM -
2 Votes
Date Functions
If you are using SQL 2008+ then you can use CONVERT function to display date alone [no time]: SELECT CONVERT(DATE, GETDATE() - DAY(GETDATE()) + ...Answered | 5 Replies | 2307 Views | Created by Brown256 - Thursday, June 28, 2012 5:26 PM | Last reply by Brown256 - Thursday, June 28, 2012 5:48 PM -
0 Votes
Date function
The primary reason is "We are programmer" The primary reason it's bad is because the data represents a date, so we want to be able to process ...Answered | 10 Replies | 1645 Views | Created by ejazahmedmukhtar - Sunday, April 14, 2013 3:56 PM | Last reply by Ehsan Mohammadi - Monday, April 15, 2013 1:32 AM -
1 Votes
date function
SET @date='20120225' SELECT ....... where Dateofservice between dateadd(day,-28,@date) and ...Answered | 3 Replies | 2303 Views | Created by go-iris - Thursday, May 10, 2012 4:40 AM | Last reply by Satheesh Variath - Thursday, May 10, 2012 6:47 AM -
3 Votes
Problems with date function
Wow a lot of good help guys.Answered | 11 Replies | 934 Views | Created by Diango - Friday, January 17, 2014 3:43 PM | Last reply by SQLZealots - Friday, January 17, 2014 6:28 PM -
2 Votes
Help in query and date function
SELECT pind,typ, code, MAX(edate) edate FROM #TP WHERE (typ = 'HLH1' and code NOT in ('2','5')) OR (typ <> ...Answered | 3 Replies | 2849 Views | Created by Kevin Ruth - Monday, October 3, 2011 1:10 PM | Last reply by Kevin Ruth - Monday, October 3, 2011 1:23 PM -
4 Votes
DAX date functions
No problem :)Regards, Michael Please remember to mark a post that answers your question as an answer...If a post doesn't ...Answered | 10 Replies | 3011 Views | Created by Murali dhar - Monday, February 24, 2014 7:34 PM | Last reply by Murali dhar - Wednesday, February 26, 2014 7:35 PM -
1 Votes
Date constants in Partition Functions
This should also help when the partition function needs to be altered to add new months as it will not impact on the other schema deltasAnswered | 3 Replies | 3646 Views | Created by Jeremy Hartley - MiX - Thursday, July 30, 2009 11:27 AM | Last reply by Jeremy Hartley - MiX - Wednesday, August 5, 2009 11:33 AM -
1 Votes
Find function not searching Dates
MATCH will find dates with one caveat: the date to be found must be passed as a LONG for the search argument.Answered | 3 Replies | 1530 Views | Created by Excel learner - Saturday, October 27, 2012 3:20 AM | Last reply by Excel learner - Tuesday, October 30, 2012 1:13 PM -
0 Votes
Date functions
If you have found any of my posts helpful then please vote them as helpful.Answered | 2 Replies | 1332 Views | Created by Ychinnari - Saturday, May 11, 2013 1:40 PM | Last reply by Chongtham Rajen Singh - Sunday, May 12, 2013 11:47 AM -
0 Votes
Index of MDX date Function
[Par Period] as ParallelPeriod ([Date].Answered | 1 Replies | 2497 Views | Created by M Sarfraz - Tuesday, October 23, 2012 10:16 AM | Last reply by Yogisha Bhat - Tuesday, October 23, 2012 12:24 PM -
0 Votes
Problems with Date() Function
In my newly installed Access 2013 the function Date() is an unrecognised function.Answered | 2 Replies | 1494 Views | Created by IanPMck - Thursday, August 1, 2013 2:51 PM | Last reply by Luiz F Fonseca C - Friday, October 26, 2018 8:43 PM -
1 Votes
Undefined function Date in expression
>Undefined function "Date" in expression Normally, there are three kinds of reasons.Answered | 2 Replies | 11775 Views | Created by Joreli - Tuesday, August 2, 2016 11:44 PM | Last reply by Chenchen Li - Wednesday, August 3, 2016 6:22 AM -
0 Votes
date functions in infopath
thanks I figured something out yesterday: used add seconds function to roll back 19 hours then used substring to remove the time part from the datetimeAnswered | 5 Replies | 7827 Views | Created by Nehemiah Willis - Wednesday, September 23, 2009 7:53 PM | Last reply by Alec Pojidaev - Friday, September 25, 2009 4:30 PM -
0 Votes
is there a date count function in vb?
Dim Date1 As New Date(2010, 1, 1) Dim Date2 As New Date(2010, 5, 19) Dim ts As TimeSpan = Date2.Subtract(Date1) Dim ...Answered | 3 Replies | 2943 Views | Created by OngYoung - Monday, April 12, 2010 5:16 AM | Last reply by _asgar - Monday, April 12, 2010 5:40 AM - Items 1 to 20 of 2668787 Next ›
No announcements
