Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
request someone to help me resolve the below iss ue.
I have a field called date1 in script from which I want to remove the timestamp and rename as date2 and hence use this to join another table which has date2.
I tried the below but both did not work please can some one guide me???
Date(Floor([Delivery Beg Date])) as Delivery Beg Date1
DATE(FLOOR(Timestamp#([Delivery Beg Date])),'DD/MM/YYYY') as Delivery Beg Date1
I have attached the test file with a text box as well but it doesn't work.
regards,
Sahana
Were missing the hh:mm part of format. It works like:
DATE(FLOOR(Timestamp#([Delivery Beg Date],'DD/MM/YYYY hh:mm') ))
Hi Sahana,
Have you tried this?
Date(Floor(Date#(date1)),'DD/MM/YYYY') as Date2
Hope that helps
Jon
Perhaps a bracket issue. Try like:
DATE(FLOOR(Timestamp#([Delivery Beg Date],'DD/MM/YYYY') )) as Delivery Beg Date1
hi Jon,
Yes I did try it but still it doesn't work.
I have attached the test file ,where I have tried it in he text box.Please have a look and help me out.
Sahana
Hi,
Just try with
Date(Floor(DateFieldName)) as NewDate
or
Date(Floor(date#(DateFieldName,'DD/MM/YYYY hh:mm:ss'))) as NewDate
Regards
R
Hi Tresesco,
It doesn't work,I tried it.Can check in the file attached
Sahana
I have tried this but it looks a bit ugly
Date(Floor(Date#(SubField([Delivery Beg Date],' ',1))),'DD/MM/YYYY')
Were missing the hh:mm part of format. It works like:
DATE(FLOOR(Timestamp#([Delivery Beg Date],'DD/MM/YYYY hh:mm') ))
Try left(Datefield,10) and convert the format.
I couldn't load the file due to source unavailability.
Check and let me know
Hi,
Please find the attached working file.
Regards
ASHFAQ