How do I create a specific date formula for an XML Feed?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hello!
I am creating an XML Feed from my app in QuickBase that our Webmaster will use. One of the fields they require is a date and time field for today's date and the current time (that the feed is accessed). It must be formatted like this:

Wed, 02 Sep 2015 15:15:00 PST

Can someone help me create/format a field like this?

Thank you!

Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,522 Points 50k badge 2x thumb
If no one chimes into this one, contact me via the information in my profile and I will do it for you.
Photo of Scott

Scott

  • 334 Points 250 badge 2x thumb
Create a Formula - Text Field and use:
Case(DayOfWeek([Date]),"0","Sun","1","Mon","2","Tues","3","Wed","4","Thurs","5","Fri","6","Sat")&", "&Day([Date])&" "&Case(Month([Date]),"1","Jan","2","Feb","3","Mar","4","Apr","5","May","6","Jun","7","Jul","8","Aug","9","Sept","10","Oct","11","Nov","12","Dec")&" "&Year([Date])&" "&Hour([Time])&":"&Minute([Time])&":"&Second([Time])&" "&[Timezone]