No announcements
Found 1430650 threads
-
4 VotesSQL Query Date Formatting
I tried using DATENAME which gave me the mmm-yyyy I was looking for, but wasn't placing the date outputs in the correct order even though an ORDER BY CLAUSE was used as my example below. I ...Answered | 9 Replies | 717 Views | Created by vinnie_Phantom - Wednesday, August 8, 2018 3:25 PM | Last reply by Visakh16 - Thursday, August 9, 2018 10:56 AM
-
0 Votes
Problem with Date Formating - VB ASP.Net
I have read all sorts of help files on formatting the date but I am getting no where. Can you help? I have a web service that gets a compressed ...Answered | 2 Replies | 4881 Views | Created by Rich at Delta - Wednesday, December 9, 2009 2:53 AM | Last reply by Rich at Delta - Thursday, December 10, 2009 11:51 PM -
0 Votes
Document Control Register
error codes, i.e. if document is returned for Formatting or Technical Issues, the ECN number it is changed under, date completed, and the customer that the document went ...Answered | 1 Replies | 925 Views | Created by Rapunzal - Wednesday, February 26, 2014 9:50 AM | Last reply by Lindali - Thursday, February 27, 2014 7:24 AM -
0 Votes
Re: DatagridView And Date/time Formatting calculations
Would apprecaite if someone could point me in the right direction here. Using VB2005 with an access database. The access table has a date/time fieldAnswered | 1 Replies | 3299 Views | Created by Surendra Kulkarni - Monday, September 3, 2007 8:20 AM | Last reply by Rong-Chun Zhang - Thursday, September 6, 2007 11:49 AM -
1 Votes
Formatting a date value in Reporting Services
favorite I am a bit rusty and would beAnswered | 2 Replies | 403 Views | Created by William Faulkner2 - Wednesday, January 28, 2015 9:08 AM | Last reply by William Faulkner2 - Wednesday, January 28, 2015 9:33 AM -
0 Votes
Problem with date formatting- intermittently not formating to date
the serial number by using ' CONTRL SHFT ~ ' . The date changes to the serial number but when I go to formatting the cell to change it back to the date ...Answered | 1 Replies | 322 Views | Created by ed80758 - Monday, March 14, 2016 4:10 AM | Last reply by David_JunFeng - Tuesday, March 15, 2016 7:33 AM -
0 Votes
InfoPath Date Picker Conditional Formatting
Hi, I have developed an InfoPath 2010 Form and I need a bit of help with setting up conditional ...Answered | 3 Replies | 2388 Views | Created by Darji - Friday, February 14, 2014 2:51 PM | Last reply by Darji - Monday, February 17, 2014 8:45 AM -
0 Votes
Excel Conditional formatting Help
formatting to match names in columns or check Today() against Column C, but i cant get it to highlight ONLY if the date is greater. Hope someone can help ...Answered | 2 Replies | 401 Views | Created by Oz Roly - Wednesday, May 27, 2015 8:57 AM | Last reply by Oz Roly - Thursday, May 28, 2015 4:32 AM -
0 Votes
I am trying some conditional formatting and cannot get it to work quite right
I am using conditional formatting to try to get different coloured text. I have a field in a matrix that is a date - if it is less than today then it should be ...Answered | 2 Replies | 454 Views | Created by Richhol - Thursday, November 21, 2013 10:07 AM | Last reply by Richhol - Thursday, November 21, 2013 10:53 AM -
0 Votes
help forum for MS Office, SQL, Access and .net when the scope of a question crosses multiple forums.
Issue - SSRS and formatting a date to yield DD MMM YYYY and ultimately finding out Format was a valid solution. SSRS only indicates FormatDateTime ...Answered | 1 Replies | 7464 Views | Created by John Rowell - Sunday, January 17, 2010 12:03 AM | Last reply by LesterLobo - MSFT - Friday, January 29, 2010 1:04 AM -
0 Votes
Multiple Groups in CQWP?
I'm pretty new to sharepoint 2007, just setting up a site for a part of my company. They want to display their status reports all on one page with different formatting. I was planning on ...Answered | 1 Replies | 6388 Views | Created by Garfy - Thursday, June 11, 2009 4:18 PM | Last reply by Xing-Bing Yu - MSFT - Monday, June 15, 2009 7:46 AM -
0 Votes
formatting a date in Data View
Just open Data View webpart which you already created in Designer. In Data View webpart you just click on column, there you can find option called Date Time Formatting ...Answered | 2 Replies | 7881 Views | Created by andreasbbbbb - Friday, May 28, 2010 6:27 AM | Last reply by andreasbbbbb - Friday, May 28, 2010 6:50 AM -
2 Votes
Add custom data to a Collection and retrieve data from it
Hi Hans, Yep this document is formatted with direct formatting. No style tags used. However I just need to capture all this date into a collection and to check how ...Answered | 5 Replies | 460 Views | Created by Supunsam - Thursday, November 10, 2016 7:32 AM | Last reply by Hans Vogelaar MVP - Friday, November 11, 2016 10:11 AM -
0 Votes
VB Excel Macro - saveas filename with current date attached.
would pull in the current date. However, it doesn't seem to work I get a debugger error saying that it has an unexpected ending. Is there something wrong in the ...Answered | 1 Replies | 8330 Views | Created by Mary Lindholm - Wednesday, May 31, 2006 2:07 PM | Last reply by Navajo - Wednesday, May 31, 2006 8:30 PM -
0 Votes
Datetime localization based od reginal format, not on language setting
date time is in the Czech. Is possible to access “Regional format” = “Czech republic” so I can force the formatting (of numbers, dates, ...Answered | 1 Replies | 789 Views | Created by Jan_Válek - Saturday, August 9, 2014 7:42 AM | Last reply by Jan_Válek - Saturday, August 9, 2014 9:25 PM -
0 Votes
Help with date formats in queries
I am not sure how to do this due to leap years, but I suspect that with the correct date formatting, this can be calculated accurately. Does anyone know how ...Answered | 2 Replies | 586 Views | Created by Juniormint10 - Saturday, January 25, 2014 4:07 PM | Last reply by Juniormint10 - Sunday, January 26, 2014 4:26 AM -
0 Votes
Using an expression in SSRS to display rolling 12 month and year to date volumes
I need some help in writing an expression in SSRS. I have a table that contains date columns and rows that contain different types of data groups. (e.g. total number of items ...Answered | 1 Replies | 3763 Views | Created by Ravenhawk08 - Tuesday, July 29, 2014 3:28 PM | Last reply by Patrick Hurst - Tuesday, July 29, 2014 5:17 PM -
0 Votes
Highlighting text in a date field using conditional formatting
;. This works fine and allows the word Awaiting to be placed in a date field. The problem I have is that the conditional formatting does not work for the ...Answered | 3 Replies | 265 Views | Created by ChrisParkin - Tuesday, May 31, 2016 10:46 AM | Last reply by mbizup MVP - Tuesday, May 31, 2016 12:25 PM -
0 Votes
Formatting labels in chart
, to solve this problem I should use Format property. But I know only about formatting date and numbers, not strings. Can you help ...Answered | 4 Replies | 6871 Views | Created by Mik Chernomordikov - Wednesday, May 24, 2006 5:59 AM | Last reply by Robert Bruckner - Wednesday, May 24, 2006 4:31 PM -
0 Votes
Running Count & Date Formatting
come out so good. Basically I go to the cell property and choose custom formatting, input the formatting string d/mm/yyyy but it only shows 31/00/2007. Can you guys tell me what I ...Answered | 13 Replies | 5237 Views | Created by Mohd Fadzli - Friday, December 28, 2007 4:09 AM | Last reply by Mohd Fadzli - Thursday, January 3, 2008 12:59 AM
No announcements
