No announcements
Found 946 threads
-
4 Votes
FormatDateTime in rdlc report
When using the FormatDateTime function to format one of the fields I'm getting a weird string containing alpha-numeric characters.Answered | 5 Replies | 94946 Views | Created by ajay_s - Wednesday, July 26, 2006 7:04 PM | Last reply by _redcat_ - Friday, November 16, 2012 6:29 AM -
0 Votes
FormatDateTime in SQL queries
FormatDateTime is as outdated as DateAdd as concatenating the SQL string yourself.Answered | 1 Replies | 2940 Views | Created by Colin Reid - Saturday, July 7, 2012 4:15 PM | Last reply by Armin Zingler - Saturday, July 7, 2012 4:39 PM -
0 Votes
FormatDateTime problems
This returns true: Code SnippetDebug.Print DateValue((FormatDateTime(whack, 2))Answered | 1 Replies | 3418 Views | Created by cswalker21 - Thursday, June 28, 2007 3:46 PM | Last reply by kleinma - Thursday, June 28, 2007 4:03 PM -
0 Votes
formatdatetime not working
User-362586360 posted I am trying to format my time to the 24hr format by using the following code that doesnt seem to change the time from 11:56:00 AM to just 11:56 Dim dt ...Unanswered | 2 Replies | 6 Views | Created by Anonymous - Friday, November 19, 2004 1:00 PM | Last reply by Anonymous - Friday, November 19, 2004 2:45 PM -
0 Votes
FormatDateTime expression
OrderDate.Value So I tried =FormatDateTime(Fields!Answered | 2 Replies | 11341 Views | Created by Dave Kulick - Tuesday, May 16, 2006 5:50 PM | Last reply by Ravenet - Tuesday, April 15, 2008 10:23 AM -
0 Votes
Error using formatDateTime function
Instead of =FormatDateTime(Max(Fields!Unanswered | 2 Replies | 15 Views | Created by Anonymous - Tuesday, November 2, 2010 11:46 AM | Last reply by Anonymous - Friday, November 5, 2010 2:35 PM -
0 Votes
FormatDateTime ?
I am looking for something similiar to the VBScript FormatDateTime function in C#.Unanswered | 16 Replies | 201 Views | Created by Anonymous - Wednesday, August 20, 2003 1:04 PM | Last reply by Anonymous - Wednesday, August 20, 2003 3:58 PM -
0 Votes
FormatDateTime hh:mm AM/PM
You can try this =FormatDateTime(now(),DateFormat.ShortDate)& " "& ...Answered | 10 Replies | 67625 Views | Created by merkuriebg - Friday, July 11, 2008 2:17 PM | Last reply by gblumen - Wednesday, January 16, 2013 7:06 PM -
0 Votes
Corrupted FormatDateTime Results
Can you also try this expression: =FormatDateTime(CDate(Fields!Answered | 2 Replies | 9988 Views | Created by LEF1 - Sunday, July 2, 2006 2:27 AM | Last reply by Tariq Younas - Thursday, January 24, 2008 5:58 AM -
0 Votes
Asp CMS formatdatetime for Tomorrow's date
User-154051931 posted Here ya go, just tested it and it works like a charm: <a href="#" ...Answered | 3 Replies | 26 Views | Created by Anonymous - Thursday, March 29, 2007 8:16 PM | Last reply by Anonymous - Thursday, March 29, 2007 9:23 PM -
0 Votes
FormatDateTime in RDLC resulting in a WEEK # return
Using Visual Studio 2008 to create the RDLC: Is there a format similiar to FormatDateTime(Today(), DateFormat.ShortDate) [which would return May 29, 2012 for ...Proposed | 1 Replies | 3782 Views | Created by jdricker - Tuesday, May 29, 2012 2:39 PM | Last reply by Bobby15644 - Monday, May 30, 2016 1:14 PM -
0 Votes
Undefined function 'FormatDateTime' in expression.
User-27249898 posted That's because FormatDatetime is specific to access and not in sql.Answered | 4 Replies | 185 Views | Created by Anonymous - Wednesday, October 10, 2007 4:05 PM | Last reply by Anonymous - Tuesday, October 23, 2007 2:12 PM -
0 Votes
FormatDateTime returns different result on servers
User43093768 posted It depends how the FormatDateTime is implemented.Unanswered | 1 Replies | 9 Views | Created by Anonymous - Saturday, October 29, 2005 4:26 PM | Last reply by Anonymous - Sunday, October 30, 2005 12:19 AM -
0 Votes
formatdatetime function in ssrs 2008
Hello , i usually use formatdatetime(sysdate,2) to only show date.Answered | 3 Replies | 13790 Views | Created by madhavi ajjarapu - Wednesday, May 2, 2012 2:56 PM | Last reply by Jason Yousef - Wednesday, May 2, 2012 3:17 PM -
0 Votes
Use FormatDateTime in parameter display
In the predetermined set the function FormatDateTime can be used.Answered | 5 Replies | 4407 Views | Created by T Prasad - Friday, February 12, 2010 6:39 PM | Last reply by Jerry Nee - Monday, February 15, 2010 8:41 AM -
0 Votes
Easy issue - unecessarially hard solution - FormatDateTime limitations
=FormatDateTime([datefield],#dd,mmm,yyyy") doesn't compile.Answered | 2 Replies | 4486 Views | Created by John Rowell - Saturday, January 16, 2010 5:54 AM | Last reply by John Rowell - Saturday, January 16, 2010 10:47 PM -
1 Votes
FormatDateTime gives #Error after report renders
LICEDDATE.Value), formatdatetime(iif(IsDate(Fields!Answered | 3 Replies | 7920 Views | Created by Ron2012 - Monday, December 17, 2012 10:51 PM | Last reply by Ron2012 - Tuesday, December 18, 2012 12:44 AM -
0 Votes
Can we use formatDateTime with @trigger().outputs.windowStartTime.??
','''',formatDateTime(pipeline().TriggerTime, 'yyyy-MM-dd'),'''') Similar issue answered here.Proposed | 3 Replies | 1147 Views | Created by Saikrishna Tarapareddy - Wednesday, October 2, 2019 10:08 PM | Last reply by ChiragMishra-MSFT - Friday, October 18, 2019 8:55 AM -
0 Votes
FormatDateTime(Date, 2) returning date in incorrect format.
sDateTime = FormatDateTime(Date, 2)& " " & FormatDateTime(Time, 4) MsgBox sDateTime OS is XP ...Unanswered | 2 Replies | 6269 Views | Created by Sanjoy Mahato - Thursday, June 23, 2011 7:35 AM | Last reply by Kee Poppy - Tuesday, June 28, 2011 9:01 AM -
0 Votes
Tumbling Windows Destination dynamic folder erroring Make sure that every '@{' is followed by its '}
Hi Debbie, There is an invalid quotation mark ’ followed by HH in the expression, please alter it into: @{concat('/trainingdata/', ...Answered | 3 Replies | 392 Views | Created by Debbie Edwards - Tuesday, January 22, 2019 10:47 AM | Last reply by Wang Zhang - Thursday, January 24, 2019 4:56 AM - Items 1 to 20 of 946 Next ›
No announcements