Problems with makedate function

[#1]

Hello,

Can someone help me to create a date field. I have attached the data from this field. I tried the makedate function with no result.Also I tried the left function but then I got numbers instead of a dates.

with kind regards,

Aissam

[deepakk]

hi,

Can you attach some sample data or application. I am not able to open the application.

Deepak

[christophebrault]

Hi,

to transform a date field, use date() function like this :

In a text box this expression gives 01/06/2010:

=date(date#('01-06-2010 00:00:00','DD-MM-YYYY hh:mm:ss'),'DD/MM/YYYY')

if you want to use this syntax in your script, write :

date(date#(YourDateField,'DD-MM-YYYY hh:mm:ss'),'DD/MM/YYYY')

Note that date format ('DD/MM/YYYY') depends on your Set Variable at the begining of your script.

[#4]

Hello,

No results with this script. I have attached the file.

regards,

Aissam

[deepakk]

HI Aissam,

You can try out the below code

makedate(mid(trim(redSheet_date),7,4), mid(trim(redSheet_date),4,2) ,  left(trim(redSheet_date),2))

Its little weird.  Inside a the listbox I formatted the date and it worked fine. I used Date(redSheet_date,'DD-MMM-YYYY')  and it worked fine.

Deepak

[#6]

Hi,

I worked on your attached application, its working fine with "date(redSheet_date)"to create date in front end ,i hope it will work in backend also.

I have generated the date field in front end in your app, that i have attached below.

Please refer.

I hope this will resolve ur problem.

[#7]

thanks guys...

with kind regards,

Aissam