Format date from a datepicker in Julian date format

(0) Share

Report

Posted on by twistsd

Hi,

I am new to using Power apps.

I am trying to copy the date from a date picker in one datacard to another datacard and dsiplay it in Julian Date format( 21/2/22 to be displayed as 22052). I have managed to copy the date and tried using the format of "yyddd" but that displays the date as "22Mon".

Any help would be gratefully appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (38)

Answers (2)

Dant7484 154 on at

Like (0)

Report
Copy link

Link copied!
Hi,
I tried this and it worked but is kinda ugly lol
Set( _month, Text( DateTimeValue(DatePicker3.SelectedDate), "[$-en-GB]mm" ) ); Set( _day, Text( DateTimeValue(DatePicker3.SelectedDate), "[$-en-GB]dd" ) ); Set( _jDay, Switch( _month, "01", "0" & _day, "02", "0" & Value(_day)+31, "03", "0" & Value(_day)+59, "04", "0" & Value(_day)+90, "05", Value(_day)+120, "06", Value(_day)+151, "07", Value(_day)+181, "08", Value(_day)+212, "09", Value(_day)+243, "10", Value(_day)+273, "11", Value(_day)+304, "12", Value(_day)+334 ) ); Set(julianDate, Text( DateTimeValue(DatePicker3.SelectedDate), "[$-en-GB]yy" ) & _jDay)
If you want to use it as a number u need to convert it with Value(julianDate) otherwise you can just use it as it is to show the Julian date of the date picked. Good luck!

Was this reply helpful? Yes No
twistsd 65 on at

Like (0)

Report
Copy link

Link copied!

@Dant7484

Thanks for the reply.

Where would I put that code?

Thanks

Was this reply helpful? Yes No
Dant7484 154 on at

Like (0)

Report
Copy link

Link copied!
No problem, though a good thing you replied because I just saw I forgot the leap year case (add 1 day after February).
Put this code in the date picker OnChange :

Set( _month, Text( DateTimeValue(DatePicker3_1.SelectedDate), "[$-en-GB]mm" ) ); Set( _day, Text( DateTimeValue(DatePicker3_1.SelectedDate), "[$-en-GB]dd" ) ); Set(_leapYear, If(Month(Date(Year(Now()),2,29))=2, 1, 0)); // If leap year add 1 to _jday Set( _jDay, Switch( _month, "01", "0" & _day, "02", "0" & Value(_day)+31, "03", "0" & Value(_day)+59 +_leapYear, "04", "0" & Value(_day)+90 +_leapYear, "05", Value(_day)+120 +_leapYear, "06", Value(_day)+151 +_leapYear, "07", Value(_day)+181 +_leapYear, "08", Value(_day)+212 +_leapYear, "09", Value(_day)+243 +_leapYear, "10", Value(_day)+273 +_leapYear, "11", Value(_day)+304 +_leapYear, "12", Value(_day)+334 +_leapYear ) ); Set(julianDate, Text( DateTimeValue(DatePicker3_1.SelectedDate), "[$-en-GB]yy" ) & _jDay)

Was this reply helpful? Yes No
Dant7484 154 on at

Like (0)

Report
Copy link

Link copied!

Edited leap year formula

Was this reply helpful? Yes No
twistsd 65 on at

Like (0)

Report
Copy link

Link copied!

@Dant7484

Thanks for the update.

I have just tried it but it still displays the date as 22/02/2022.

Was this reply helpful? Yes No
Dant7484 154 on at

Like (0)

Report
Copy link

Link copied!

Hi, are you trying to display it in another date picker? because it wouldn't work, put julianDate in a textinput to display the value if you want to test it

Was this reply helpful? Yes No
twistsd 65 on at

Like (0)

Report
Copy link

Link copied!

@Dant7484

Thanks.
That is what I am trying to achieve. I have a datepicker to choose the date and then I want a textinput to display the value in julian date format. Could you please give me the steps I need to complete to achieve this.

Thanks

Was this reply helpful? Yes No
Dant7484 154 on at

Like (0)

Report
Copy link

Link copied!

Of course no problem. You might have to unlock the input in datacard to edit Default

Was this reply helpful? Yes No
Dant7484 154 on at

Like (0)

Report
Copy link

Link copied!

The number on the input is wrong somehow but when I picked the date its fixed idk how

Was this reply helpful? Yes No
twistsd 65 on at

Like (0)

Report
Copy link

Link copied!

@Dant7484

Thanks

I have tried that but the data card for the juilan formatted input stays blank

Was this reply helpful? Yes No