You’re offline. This is a read only version of the page.
Announcements
155
Hello all,
I'm French and I would know if I can compare 2 dates with English format which come from an Excel file and stored to Dataverse.
The first date is on my gallery and the two others date are Date Picker controls.
I have this formula but my dates have a French format. The BUDAT column has a French format in my formula and also the 2 Date Picker controls.
Filter(
T04_Weekends;
And(
And(
BUKRS in Filter(Usersrole; Email = varUser).Company;
varRole = "Contrôleur"
);
'Statut workflow' = "New" && BUDAT >= (dpFromWeekend.SelectedDate) && BUDAT <= (dpToWeekend.SelectedDate)
)
Kind regards.
Samuel.
Hi @Samny_98,
Do you want to format the French date format as the English date format?
I think you could just format all the date as the same English format using the Text() function, then compare it using the DateValue() function.
Share
Report
All responses (
Answers (
