tom007

Current date formatted

Discussion created by tom007 on Feb 25, 2014
Latest reply on Feb 26, 2014 by beverly

Hi

I forgot my skills and need to update again. Sorry the newbie question and errors:

Want to enter current date on auto-enter field.

The format must be:

yyyy-mm-dd

 

Not "/"

 

With leading zero on 1 digit day.

 

Like this: 2014-01-01

 

Get error on this calculation:

 

Let(x=Get ( CurrentDate );"")

 

Left ( x ; 2)

 

& "-" &

 

Middle ( x ; 4 ; 2 ) )

 

& "-" &

 

Right ( x ; 4)

 

The problem is that Get ( CurrentDate ) don't get leading zero, for example, gives this: 1/1/2014 with this format m/d/yy

 

Thanks.

 

Tom

Outcomes