Link to home
Start Free TrialLog in
Avatar of sanjshah12
sanjshah12Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Format Date to Iso c


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.

Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sanjshah12


Thanks Padas,

But I receive an error:

Invalid procedure call or argument: 'WeekdayName'

Any ideas?
oops, that should be

dayname =WeekdayName(Weekday(theDate),true)
Thanks padas, that worked perfectly!