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
