Posted Fri, 12 Feb 2021 17:00:54 GMT by Michael Weingand Professional Services Manager
I have a client who needs a field called "File Name" concatenated which is no problem but they want the date to read in the following format.
yearmonthday (210212).  the year is just a 2 digit not 4 but that is not as important as transforming it from 02/12/2021 which is what we are capturing.

Can anyone help?
Posted Fri, 12 Feb 2021 18:40:44 GMT by Jon Weston File IT Solutions Sr Application Developer and RIM specialist
Hi Michael,
Play around with the Format() function (details here ).  Something like Format(DW_YOURDATE, "YYDDMM") should do the trick.  I just glanced at a workflow of mine and I'm using Format(DW_HIRE_DATE, "MMM d yyyy") to make a date output like this "Feb 2 2021"

You must be signed in to post in this forum.