CurrentDate format problem

[bluebulb]

The [FMP-CurrentDate:short] tag produces a date in the MM/DD/YY format. FileMakerPro's short date format is MM/DD/YYYY. So an search generated via a CDML tag will fail.

Anyone know a way around this?

Thanks, PK

[Keith M. Davie]

I hope that through your own experimentation you have resolved this issue by now. If not, you may want to look back (around Feb this year) in this forum for a topic entitled "currentdate - Research is good for the soul ", whcih I began. Also look at the thread by Turansky to which it refers. You may find some useful information there.

[Vaughan]

According to the CDML reference, the dates are returned according to the short and long date formats defined by the operating system.

Try changing the country preferences for your computer and see if it makes a difference.

[Garry Claridge]

Is the page with the [FMP-CurrentDate] tag being processed by WebCompanion first?

All the best.

Garry

[bluebulb]

Apologies for not looking carefully through past posts before askig the question. Thanks Keith for pointing this out.

Just in case anyone is looking a solution and comes across this posting, here's what I did:

Created a calculation field called "Today"

Today=Status(CurrentDate)

The calculation result is Date. And, it is an unstored calculation result.

This produces the current date in the same format that FileMakerPro uses, so the CDML compares this field to the date entered by FilemakerPro when the record was created.

Thanks

[Keith M. Davie]

Glad it helped. I knew it was there and was too lazy to write it out.