• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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
0
kali958
Asked:
kali958
  • 2
  • 2
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
What you did would have been my advice, well, almost:
      @TextToTime(@Text(Billing_Start)) <=@Today

What you could add is a test to find out if Billing_Start really is a date-value.

      x:= @TextToTime(@Text(Billing_Start));
      @If(@IsTime(x); x<=@Today; @True)
0
 
kali958Author Commented:
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!
0
 
kali958Author Commented:
Thanks again for you help, I really appreciate it!
0
 
Sjef BosmanGroupware ConsultantCommented:
You might have tried @IsError as well, I suppose it would have worked just as well. Thanks for the kind words. :-)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now