Link to home
Start Free TrialLog in
Avatar of kali958
kali958Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kali958

ASKER

Perfect - I was on the same path. I did a:=@TextToTime(@Text(Billing_Start) but the part i was really look for was the @IsTime, I did not think to use that one...

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!
Avatar of kali958

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. :-)