Dates: Format to ddMMMyy

I've gone through various date related threads with calculations and widges but can't work out how to achieve this...

need the output from a date field (ideally from a date picker) to be ddMMMyy (i.e. like 29jan18)

The final output is required for a calculated field which is combining the text from multiple fields (it's actually producing an analytics URL with various fields added to the end of the URL)

What you are looking for is called a date string.

1) Add a date picker field

2) Add a form calculation widget

3) Open the wizard for the form calculation widget (magic wand icon)

4) Click on the three dots button and scroll down to the bottom. You will see the dateString function 

5) Add your date picker field as a parameter to the dateString function.

6) Hit the green save button

For example:

It will look like this:

Demo is here:

https://form.jotform.com/80283927236966

Thanks very much for the assistance.

And from the string field, is there a way to mod that output to remove spaces, e.g. to end up with the output "29jan18"?

OK, you mean like this:

https://form.jotform.com/80283927236966

I used three substring widgets to extract the day, month, and year into separate fields.

For example "month" looks like this:

Then I added a short text field. And appended each separate field together.

Condition looks like this:

Thank you, that's excellent!

Final question - is there a function/widget to put the entry into lower case?

Thank you, that's excellent!

Welcome, happy you like it.

Final question - is there a function/widget to put the entry into lower case?

You can use CSS to transform the text to lowercase. 

First get the field ID from the properties (gear icon) on the advanced tab.

For example:

The CSS looks like this:

#input_5, #input_8 {

  text-transform: lowercase !important;

}

How-to-Inject-Custom-CSS-Codes 

I updated the demo. Its working here:

https://form.jotform.com/80283927236966