Terrell Posted December 31, 2000 Posted December 31, 2000 Hi I need to return a date in a text calculation as 11-Mar-00 from an existing field example Name & " " & Date & " " & Cost "John 02-Jun-00 10.00" I'm currently using DD/MM/YYYY with "DateToText(DateFrom)" in the calculation but need it formatted with short month name for export! Can anyone help? Happy New Year T
LiveOak Posted January 1, 2001 Posted January 1, 2001 To get the short month name, how about: Choose(Month(Date), "", "Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") -bd
George Posted January 2, 2001 Posted January 2, 2001 Live Oak, I have a problem with a lookup which the choose function aleviates one part of my problem which is requiring me to manually perform a screen refresh: http://www.fmforums.com/ubb/Forum26/HTML/000956.html I have been trying the 'case' and 'if then else' functions in my field calculated values. I just read your suggestion on this post and thought I would give it a try. It works except that it always looks up and returns the value for the first value Product::PRICE1. Can you suggest an alteration which would choose the correct pricing level with respect to the invoices discount level? [This message has been edited by George (edited January 01, 2001).]
Terrell Posted January 2, 2001 Author Posted January 2, 2001 Thanks LiveOak, that works fine but I'm getting the year as "YYYY" how do I return "YY" ie "11-Jan-00" the text calculation I'm using is: If(IsEmpty(DateFrom); ""; Day(DateFrom) & "-" & Choose(Month(DateFrom); ""; "Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"Aug";"Sep";"Oct";"Nov";"Dec") & "-" & Year(DateFrom)) & TabFM & ...
Recommended Posts
This topic is 8978 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now