• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 7 subscribers
  • Views 3931 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Function to return date in format YYYYMMDD

joep45

Is there a simple function to return date in format YYYYMMDD. I need to query DB2 and they require that format, i can construct one but its seems overly complicated

...

OriginalPostID-104919

OriginalPostID-104919

  Discussion posts and replies are publicly visible

Parents
  • 0
    datetext() works but make sure to test - I believe if you do not convert to GMT it may return 1 day previous to the input. As I have had that issue, I now use this expression in a rule to return YYYYMMDD (with 'dateIn' as a Date type parameter):

    =tostring ( year ( ri!DateIN ) ) & substitute ( padleft ( tostring ( month ( ri!DateIN ) ) , 2 ) , " " , "0" ) & substitute ( padleft ( tostring ( day ( ri!DateIN ) ) , 2 ) , " " , "0" )
Reply
  • 0
    datetext() works but make sure to test - I believe if you do not convert to GMT it may return 1 day previous to the input. As I have had that issue, I now use this expression in a rule to return YYYYMMDD (with 'dateIn' as a Date type parameter):

    =tostring ( year ( ri!DateIN ) ) & substitute ( padleft ( tostring ( month ( ri!DateIN ) ) , 2 ) , " " , "0" ) & substitute ( padleft ( tostring ( day ( ri!DateIN ) ) , 2 ) , " " , "0" )
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.