Cannot search for a specific year in a date text box (only month)

[#1]

Hi,

I have a classical text box with a field date in it. The original format is date so like 45535. In the text box, I put a format date (YYYY/MM/DD) and when searching in the text box, only the month are searched....

So if I type 2, only the date with 2 in the month is selected but not the year starting by 2.... Typing 2012 will give me no result...

I tried to change the date format to YYYYMMDD ou YYYY_MM_DD but no luck....

Thanks in advance for your help!

[ashwanin]

Change date format at Script level by

Date ( FiledName,'DD-MMM-YYYY') as FieldName

[#3]

Hi,

Change the Date Format at Document Setting --> Number .It works, I had similar kind of issue.

Thank you.

[#4]

Thanks I'm trying it....

[#5]

Thanks but if I put number my date will look like 45532, 45533,.... so it's not usable

[#6]

Under Number Tab, change the format as Data.

[#7]

I tried it's not working.

Thanks

[sunilkumarqv]

TRY THIS AT YOUR SCRIPT

=date(date#(DateStringField, 'YYYY-MM-DD'), 'DD-MM-YYYY') AS DateField

[#9]

ok I tried it's not working.

If I let the format by default my date are now 12-dec-2010

When I type 20, it will give me no answer.... When I type 19 it will select only 19 as day not year.

If I changed back the format only in text box to M/D/YYYY, it will select also only the day.

If I changed back the format only in text box to YYYY/M/D, it will select the first 2 digit of year when type 19 but if I type another number like 198, nothing is available but I do have date like 1990-10-24

[#10]

Thanks I'm trying it!

ok it's not working