Hi there,
I have a time log form (formA) that has two computed date/time fields.
When saved, this form generates various project time cards using another form (formB) based upon the info users punch in. Every FormB document has a button that opens its parent formA.
On formB the date/ time fields (StartDate and EndDate - computed for display - use preferences from: user settings) show up in the format mm/dd/yyyy, but i noticed some duplicate formB type documents that show the dates as dd/mm/yyyy. On these documents when i click on the button to open parent formA i get a ‘type mismatch’ error. Since these are duplicates i have been asked to delete them. So i thought of creating a separate view to filter them out and delete them.
Being a beginner it was hard for me to programetically differentiate between date and month when date is less than 12. So to give a start I created a view with selection formula i used is as follows:
SELECT Form = “timeresponse” & (@Left(@Text(BeginDate);2) > 12)
This did not give any documents at all in the view. However to test the code i created a column item as @Left(@Text(BeginDate);2) - and that returned a value in the column.
i can’t understand why this value cannot compare with numeric 12 and show relevant documents. What am i missing here?
Is there was way i could filter all the duplicate documents that have dates less or equal to 12?
Thanks for all your help!
Ayaz