Originally posted by: MorryP

I have a submitter who is sending their DOB as MM/DD/CCYY, but they are dropping the leading zeroes in the MM and DD.  I can't seem to get a custom date format created right where the file validates with input like:

1/15/2016

11/4/2016

6/4/2016

12/15/2016

What I need, I guess, is [M]M/[D]D/CCYY but I can't figure out how to get that created in type designer.

Originally posted by: DeM0n

Use TODATETIME() function....you can define the format of the output in any way you want....

Originally posted by: MorryP

I found out that M/D/CCYY handles 1 or 2 digit Month and Day.  After all this time, I didn't know that.

Originally posted by: DeM0n

Can you tell me exactly whats your input date and what are you looking for in the output ?

Originally posted by: @vkprasad_WTX

I think Morry you are expecting if you get input data as below

11/15/2016
8/18/2016
08/18/2016
12/12/2016
01/18/2016

so then you want output as like this

11/15/2016
8/18/2016
8/18/2016
12/12/2016
1/18/2016

For this I developed one PI for you may be it will be use full for you

Thanks

prasad

Attachment(s)

DATEFORMAT.zip   2 KB 1 version