Date Format MM/dd/yyyy Returning single Digit Months/Days

[H27790]

I have strings, startDate, endDate, showStartDate, and showEndDate. Any text field I use them in will dislay 01/01/2020 12:00AM as 1/1/2020 12:00AM. I just want 01/01/2020. Nothing I have done, including use of 'Pattern' in the field settings, has changed the format. What else can I try?

[luked]

Hi there,

If you are using an SQL query to pull your data you will need to adjust the format in the query. Using the pattern in the field will not change the SQL format.

[jgust]

If the field was a date datatype then you can use the pattern "M/dd/yyyy".

Since the incoming field is a fixed-length string you can grab the first 10 characters:

MID("01/01/2020 12:00AM",1,10)[/code]

@luked suggestion gives you the most flexibility.  Converting the field to the proper datatype in SQL then you can use pattern and later if you need to do date calculations you can do that with no effort.

[H27790]

How do I accomplish this in Jaspersoft Studio?