formatdate

Discussion List

• Date formats...

  Earlier today I received the below email from a customer which I wanted to post on here in case the…

  43 views 1 comment 0 points Most recent by Danny Roden July 2023General
• Get the 6 month Older Date from Today

  Is there any easy way to get the date which is 6 months older than today?

  44 views 2 comments 0 points Most recent by Mahulima February 2023General
• Batch timestamp format

  I've created a number of DQ outputs running of a scheduled workflow to create a multibatch dataset …

  Answered 67 views 4 comments 0 points Most recent by Henry Simms September 2022General
• Created date columns

  Created date columns. They converted to alphanumeric. When I try to perform a compare date/time o…

  Answered 63 views 1 comment 0 points Most recent by Henry Simms August 2022General
• How to validate US dates stored as YYYY-MM-DD

  I have several fields that have dates stored in the format above. If I run the built in function &q…

  Answered ✓ 32 views 2 comments 0 points Most recent by James Sidebotham March 2022General
• Issue with dates being read as American dates

  I am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When ann…

  Answered 53 views 5 comments 0 points Most recent by Henry Simms January 2022General
• How to convert unix timestamps to human-readable date?

  Hi, Does any one know how to convert Unix timestamps to human-readable date? Example Unix timestamp…

  Answered ✓ 117 views 5 comments 1 point Most recent by Clinton Jones April 2021General