Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
Can you attach some sample data or application. I am not able to open the application.
Deepak
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.
Hello,
No results with this script. I have attached the file.
regards,
Aissam
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
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.
thanks guys...
with kind regards,
Aissam