Viewing 15 posts - 46 through 60 (of 152 total)
October 16, 2017 at 11:40 am
FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy')REPLACE(CONVERT(varchar(10), Invoice_Exceptions.DateTime,101),'/','-')Hopefully that'll speed things...
October 16, 2017 at 11:28 am
LTRIM(RIGHT(CONVERT(varchar(20),[ie].[DateTime],100),7))October 16, 2017 at 11:15 am
LTRIM(RIGHT(CONVERT(varchar(20),[ie].[DateTime],100),7))October 16, 2017 at 11:05 am
October 11, 2017 at 2:24 pm
chef423 - Wednesday, October 11, 2017 2:17 PMLuis, thanks! Phil, you as well....I appreciate you both.
FINISHED CODE:
Select Invoice_Exceptions.Invoice_Number, FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy')...
October 11, 2017 at 2:18 pm
Luis, thanks! Phil, you as well....I appreciate you both.
October 11, 2017 at 2:17 pm
October 11, 2017 at 1:50 pm
FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy hh:mm tt')
Wow, I feel like a numskull, I swear I tried that....thanks again.
October 11, 2017 at 1:34 pm
June 14, 2017 at 4:28 pm
This should be a more educated response!!
Please let me know...this is actual queried data that I pulled the Ticket_ID from and all the corresponding data to get...
June 14, 2017 at 2:07 pm
Viewing 15 posts - 46 through 60 (of 152 total)