Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Long Format for Date needs to stay long

Turansky
in Calculation Engine (Define Fields)

Featured Replies

I have created a field based on a calculation to come up with a date. Then I format that field to make it look like a long date format. My problem is when I'm trying to pull this information using CDML it will only pull the short format? Is there a way to make the long format stay long?

Thank you

Kent

Create a calc field that returns text with the following calculation:

DayName(Date) & ", " & MonthName(Date) & " " & Day(Date) & ", " & Year(Date)

That way, it'll come out as:

"Thursday, February 6, 2002"

Just export the calc field.

  • Author

Getting Closer,

This seem to work pretty good. My year just stays at the year "6" no matter what I change the month, day, year to. Any sugetions for that?

Thank you

KT

Create an account or sign in to comment

https://fmforums.com/topic/3493-long-format-for-date-needs-to-stay-long/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.