Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Conversion

Status
Not open for further replies.

Mags1972

IS-IT--Management
Feb 28, 2005
24
GB
This hopefully should be a very simple one, but my mind has just gone blank!!!

I have 2 dates (input is DDMM , output is CCYY-MM-DD), just mapping one to the other produces a "one or more outputs in invalid" - due to the ##'s being inserted.

What am I doing wrong?

Thanks
 
what's you mapping rule - are you putting anything in the CCYY part?
 
am just simply dragging and dropping.

The help option states that Mercator should insert the year automatically..

I think I'm going mad!!
 
its amazing what 10 minutes in the fresh air does!!!

Sorted

=Texttodate(Left(datetotext(CURRENTDATETIME( )),4) + datetotext(In1))


Thanks anyway.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top