Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Date formatting using XML as time reference

Date formatting using XML as time reference

Date formatting using XML as time reference

First off, Hi there! Nice to see that I'm not the only person that has formscape problems.

I'm building a coupon to be valid for 30 days from the date of sale. I have completed the date from number conversions and I can make it work with 'today' as a reference date. but the issue with that is the invoice document can be reprinted at anytime making the coupon valid for 30 days from the date of printing rather than from the date of sale.

The date of sale is contained in the xml, but the date formatting objects to not recognise the values. The formatting of the date objects looks correct.

Anyone any suggestions??
All help appreciaed.

RE: Date formatting using XML as time reference

text box
date from number
first : number from date
xml content p.ex. 20/07/2008
second : number
p.ex. 30

You have to check the date format in 'date from number' and in 'number from date'. Use dd for the days, MM for the months and yyyy for the years. Also do not forget the signs like / or - between. I have tested and it works. So not, let me know your email.

RE: Date formatting using XML as time reference

has my advice been helpfull ?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close