kali958
asked on
Date Field reading date as Text
I have a database that has 1 form that contains how much someone will be charged for their account. It has a field called Billing_Start. It is a Time/Date field.
When the date is 2008 or greater the field show the date as Time\Date in the document. But if the date is from 2007 it is reading it as Text
The billing view that I have created has the following filter Billing_Start <=@Today.
I do not want to charge people until the 90 day grace period it up, and that function is working but it is not showing the accounts from 2007.
I have tried @TextToTime(@Text(Billing_ Start)) <=@TextToTime(@Text(@Today )) and that does not work either
Any help would be appreciated! Thank you
When the date is 2008 or greater the field show the date as Time\Date in the document. But if the date is from 2007 it is reading it as Text
The billing view that I have created has the following filter Billing_Start <=@Today.
I do not want to charge people until the 90 day grace period it up, and that function is working but it is not showing the accounts from 2007.
I have tried @TextToTime(@Text(Billing_
Any help would be appreciated! Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again for you help, I really appreciate it!
You might have tried @IsError as well, I suppose it would have worked just as well. Thanks for the kind words. :-)
ASKER
I knew that somehow somewhere there was something to say If it is Time, do this if not then do X.
Thank you again, this was really helpful!