Avatar of sanjshah12
sanjshah12
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Format Date to Iso c

Hi,

I have 2 fields in my DB that are required to be formatted to JS iso c format, i.e.

Mon Jun 11 2012 10:00:00 GMT+0100 (GMT Daylight Time)

the fields in my DB are set to 21/10/2012 and 10:00

is there an easy way to format this to the required format?

I can do the right hand part by concatenation :

StartTime & ":00 GMT+0100 (GMT Daylight Time)"

but struggling with the left hand part.

Thanks
ASPJavaScriptMicrosoft SQL Server

Avatar of undefined
Last Comment
sanjshah12

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Scott Fell

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
sanjshah12

ASKER
Thanks Padas,

But I receive an error:

Invalid procedure call or argument: 'WeekdayName'

Any ideas?
Scott Fell

oops, that should be

dayname =WeekdayName(Weekday(theDate),true)
sanjshah12

ASKER
Thanks padas, that worked perfectly!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck