Enhancements

Add more options for date bookmarks

Recommending 2 more date bookmarks which should be formatted independent from the systems date region settings.

Currently the bookmark DATE = system format

Can I recommend a SHORTDATE which is formatted as MMMM d, yyyy (‎September ‎19, ‎2019)

And a FULLDATE which would populate for example (19th day of September, 2019)

Independent of the system / user settings as I have some users that prefer the default format dddd, MMMM dd, yyyy as it effects the date format in Work and Excel functions.

I’m currently working around the date issue with a nightly SQL job. My examples

-- Insert new CaseID’s into the table UC, OPEN, and SETTLED

INSERT INTO TrialWorks.dbo.UDD_KJA (ClientID) SELECT ClientID FROM TrialWorks.dbo.Clients

WHERE CaseId IN (SELECT CaseID FROM TrialWorks.dbo.CaseTable

WHERE [Case Status] IN (1,2,8)) AND ClientId NOT IN (SELECT ClientId FROM Works.dbo.UDD_KJA )

UPDATE TrialWorks.dbo.UDD_KJA SET ConfirmedBy = Cast(DAY(GETDATE()) as Varchar(2)) +

CASE WHEN DAY(GETDATE()) in (1,21,31) THEN 'st' WHEN DAY(GETDATE()) IN (2,22) then 'nd' WHEN DAY(GETDATE()) IN (3,23) then 'rd' ELSE 'th ' end

+ 'day of ' + DATENAME(month, GETDATE()) + ', ' + convert(varchar(4),year(GETDATE()))

  • Guest
  • Mar 26 2020
  • Attach files