CONVERT DATE-TIME DATA TYPE TO TEXT TYPE

Comments

2 comments

  • Avatar
    Nathan Giusti

    GETMONTH([date]) + '/' + GETDAY([date]) + '/' + GETYEAR([date]) + " " + GETHOUR([date]) + ":" + GETMINUTE([date])

     

    I free handed this so you may need to convert the values of the functions to strings to get the concatenation to work right. But essentially just use these build in functions to extract the information you need and build the string you'd like.

    1
    Comment actions Permalink
  • Avatar
    Master Yoda

    Thanks a lot!

    0
    Comment actions Permalink

Please sign in to leave a comment.