Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A customer has a set of date values in different formats. Some dates are in Julian date format; some dates are text strings. How can a developer ensure the data is loaded in a consistent format? <a href="https://www.credosystemz.com/training-in-chennai/best-amazon-web-services-training-in-chennai/">awstraininginvelachery</a>
the julian date can be processed by: .
Date(MakeDate(1900 +(left(text(Julian_Date),1)* 100) +
mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) )
more information in this link : Julian calendar